How do i do sort a to z fomulas for a column - Microsoft EXCEL 2004 for Mac

Move the column to A. Mark entire sheet and sort ascending. There are more raffined ways to do this, but this is an easy quick fix...

In a column adjacent to your data, enter the formula

=RIGHT(A1,4)

and copy down as far as you need to go. Then, sort on that column.

HI,

Please follow the given link ,i think this will be more helpfull to you.

http://tutorial.math.lamar.edu/Classes/CalcII/PolarArcLength.aspx

good luck

Typically it would be

=AVG([RangeStart]:[RangeStop]) + [CurveValue]

unless your instructor is using standard deviation instead of mean.

are you using mssql then it must be something like this

Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname

You need to click on the arrow on top of Date Column, and not subject column.
Let me know if you cannot see the date column.

One way of finding (and removing) duplicate entries is to sort the column and put a simple formulate in a temporary column next to that column; for example - if column A has duplicates, insert a column (B) and starting in B2 put if(A2=A1,"DUP",""). Select B2 and scroll down to the bottom of your spreadsheet. Press <ctrl>-D to extend the formula in B2. Wherever there is a duplicate you'll see "DUP" in column B. If you want to remove the duplicates copy column B and Edit / Paste Special... with "values" selected (to wipe out the formula). You can then sort the spreadsheet on column B and remove rows with DUP in column B.

If you can't delete the duplicate rows and the order is important first include a column that captures the order - same trick except put row() in that column, copy / paste special the values and then you can re-sort after doing the above to have both the DUPs marked and the original order.

Hope that helps.

dear monalinda you have to enter formula in formula bar with = sign and select the coloumn & rows

Look at the formulae for half an hour each night just before going to bed.