| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sorting data, formula contance
When I sort a group of cells by highest number to lowest one column changes
the formula to match where the cell moves to. So if cell J9 moves to cell J8 in the sorting, the formula in the j column adjusts accordingly to match the new position by one. I want the formula to remain constant. How do i do that? Basically, if the formula in J9 is =E9/G30 and J9 moves to J8 I want it to stay =E8/G30, but right now it keeps changing to =E8/G29. Catch my drift? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting all rows of data that have a value in a particular column | Excel Discussion (Misc queries) | |||
| Data compiling formula | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
