Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula won't adjust after sorting data
I use 2003 Excel. If I write a formula which works properly with the data
sorted by column A and then sort by a different column it no longer works. There are two main groups that I need to sort by. Sometimes I need the data sorted alphabetically (column A) and sometimes I need it sorted by groups (column G). If I write a formula in cell (J50) while sorted alphabetically and then sort by groups the formula in cell (J50) might move to cell (J40) and the data that is referenced by that formula could be scattered anywhere on the sheet so the formula is no longer relevant. Is there any way to make the formula adjust to where it will still refer to the same data even if the data and the formula cells move after being sorted? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |