Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TABLE ROW SORT ERROR?
Hi all - I have a 22+ column by 867 row table. Three columns host formulas
on each row that refer to values on the same row. Everything is fine until I sort and/or filter. Then, the formulas point to other rows, even though the right values appear on each row. All rows and columns are included in the table. Can anyone shed some light here? Thanx, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TABLE ROW SORT ERROR?
Hi Ray,
My shot in the dark is that you are not sorting or filtering ALL the columns that contain formulas and values as a whole, or you have formulas with indirect, count, or other commands that rely on specific placements. What are examples of your formulas? Squeaky. "RAY" wrote: Hi all - I have a 22+ column by 867 row table. Three columns host formulas on each row that refer to values on the same row. Everything is fine until I sort and/or filter. Then, the formulas point to other rows, even though the right values appear on each row. All rows and columns are included in the table. Can anyone shed some light here? Thanx, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Sort Error | Excel Discussion (Misc queries) | |||
vlookup and sort error | Excel Worksheet Functions | |||
Sort error | Excel Discussion (Misc queries) | |||
Pivot Table Sort Error | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) |