Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort data w/ formulas? ...
Hey guys, I posted elsewhere but I think this might be more
appropriate here. I'm trying to sort several columns and rows in a worksheet. I want to sort it by my 'totals' column which is actually derived via a simple formula. For example, the value displayed in the cell might be '48', but the actual contents of the cell a "=COUNTIF(Full_List_QA!F2:F401, Sums_QA!E9)". I can't get it to work the way I expected to at all. Is there a trick to this or a simple technique I'm not doing? All help and pointers to info appreciated. ;-) Thanks! Chris http://amateureconblog.blogspot.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when I data sort my formulas change | Excel Worksheet Functions | |||
Sort Formulas? | Excel Worksheet Functions | |||
sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) |