Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep my numbers while sorting?
I am using excell 2003 and I am trying to sort my sales for the year by
column. I can sort fine however the formulas aren't moving with my sort so some of my numbers are off. Example: A 5 D 7 C 1 B 8 E D+C After sort A 5 B 8 C 1 D 7 E B+C This is really messing with the reports that I am trying to generate using this formula so if anyone can help me I would greatly appreciate it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep my numbers while sorting?
On Nov 20, 10:34 am, New2Excell
wrote: I am using excell 2003 and I am trying to sort my sales for the year by column. I can sort fine however the formulas aren't moving with my sort so some of my numbers are off. Example: A 5 D 7 C 1 B 8 E D+C After sort A 5 B 8 C 1 D 7 E B+C This is really messing with the reports that I am trying to generate using this formula so if anyone can help me I would greatly appreciate it. I like to use the LIST feature that is new with 2003. Highlight the data that you want to be sorted. Include everythign that you want to correspond to it. Right click, choose create list, if you have selected headers then select that option. Click ok. Now use the pull downs to do all of your sorting. Another thought is that you have $ in your formulas, so it woudl nto matter where you move the data it will still refer to the original cell. The dollar sign makes the formula always look to that row or column. Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting high numbers from low numbers between two rows | New Users to Excel | |||
Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
Sorting numbers with differing numbers of digits | Excel Discussion (Misc queries) | |||
sorting whole numbers | Excel Worksheet Functions | |||
Sorting numbers | New Users to Excel |