Question about Microsoft EXCEL 2004 for Mac

1 Answer

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

Posted by Anonymous on


1 Answer


  • Level 1:

    An expert who has achieved level 1.

    New Friend:

    An expert that has 1 follower.


    An expert that has over 10 points.

    Welcome Back:

    Visited the website for 2 consecutive days.

  • Contributor
  • 18 Answers

Posted on May 30, 2014


Add Your Answer


Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

I have a column containing a value of a single letter. I need the spreadsheet to sort add rows by letter.

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...

Sep 07, 2014 | Microsoft Excel for PC


Display the size of messages - Windows Live Mail

<span>1.The</span> <span>Windows</span> <span>Live</span> <span>Mail</span><span>,</span> <span>open</span> <span>the</span> <span>View</span> <span>tab</span><span>.</span><br /><span> <span>2.Cliquez click reading pane and then click below for the list of messages. </span><span>Display columns only works when the reading pane is not right.</span> <span> 3 Columns are displayed in the list of messages. 4. Add or remove columns, click view and then click Select columns. <span>5.Cochez then the boxes before the information to be displayed, size for exp messages and uncheck columns do not display. </span><span>Validate by OK.</span> <span> 6. Size messages is displayed in the list. <span>7.Cliquez on the header of the size column to sort the messages by size. </span><span>Click on the heading date to sort by date of receipt.</span> </span></span></span>

on Jan 03, 2011 | Computers & Internet

1 Answer

Excel sort last four list of telephone numbers

In a column adjacent to your data, enter the formula


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

Feb 25, 2012 | Microsoft Office Standard for PC

1 Answer

If there is an employee table containing salary column how to find the 3rd maximum salary in the salary column?

What software are you using? If you are using EXCEL, it's simple to select the column,
and then click 'Data' as 'SORT' and choose 'Descending', and then to pick the 3rd row in the ordered column.

Mar 30, 2011 | Microsoft Computers & Internet

1 Answer

.,I wanna know watz da' fomula in computang grdes

Typically it would be

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

unless your instructor is using standard deviation instead of mean.

Mar 19, 2010 | Microsoft EXCEL 2004 for Mac

2 Answers

Sorting a single column with both first name and last name

are you using mssql then it must be something like this

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

Sep 26, 2009 | Computers & Internet

1 Answer


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.

Jul 28, 2009 | Dell Computers & Internet

1 Answer

About formula

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.

Aug 08, 2008 | Microsoft Computers & Internet

1 Answer

Ms excel fomulas

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

Sep 24, 2007 | Microsoft Office Standard for PC

1 Answer


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

Sep 11, 2007 | Video Cameras

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo


Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts


Level 3 Expert

1997 Answers


Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides