| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort affects formula
I use Excel to manage records (rows) of data.
Data (a cell) in any given row uses a formula which makes use of data from a different row. The rows may or may not be sequential. When I sort the rows the formulas, since the rows change order, they no longer point to the correct data (cell). It there a straight forward way of accomplishing this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sales history and how Unit Price affects it... | Charts and Charting in Excel | |||
| hidden macro affects how other files open | Excel Discussion (Misc queries) | |||
| One workbook affects another | Excel Discussion (Misc queries) | |||
| Value part of formula exlusion/ Not affects neg's: value | Excel Discussion (Misc queries) | |||
| The cursor affects all cells it touches-how to correct? | New Users to Excel | |||
Threaded Mode
