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

Ad

1 Answer

james_dannn1

  • Level 1:

    An expert who has achieved level 1.

    New Friend:

    An expert that has 1 follower.

    Corporal:

    An expert that has over 10 points.

    Welcome Back:

    Visited the website for 2 consecutive days.

  • Contributor
  • 18 Answers

Posted on May 30, 2014

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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

Tip

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

=RIGHT(A1,4)

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

WHY ARE MY EMAILS NO LONGER SORTED IN DATE ORDER


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

Integration


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

72 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

k24674

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

Loading...