| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting By Values...NOT Formulas
I have a "source data" worksheet and a "summary" sheet. The summary
sheet contains If Formulas referencing the source data sheet. Ex: =IF(Sheet1!A1="","",Sheet1!A1). The problem is that when I sort the data on the summary sheet, it sorts by the formula contained within the cell. Is there a way to force it to sort based on value instead? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Possible avoiding cell Formulas? | New Users to Excel | |||
| Challenge: Unique Values via Formulas | Excel Discussion (Misc queries) | |||
| Sorting Formulas with "Empty" Results | Excel Worksheet Functions | |||
| sorting rows without changing order of my values! | Excel Discussion (Misc queries) | |||
| Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
Threaded Mode
