| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Unable to sort data in excel with cells containing if & hlookup
I am trying to sort a column of data in excel. The cells to be sorted have
formulas with multiple if and hlookups statements. I went through the sort wizard but I do not find the data sorted. Do you know of any limitations of sorting with formulas contained in the cells? Here is an example cell: =IF(HLOOKUP("Calendar Day",Results!$6:$146,ROW()-13,FALSE)="",NA(),IF(HLOOKUP("Calendar Day",Results!$6:$146,ROW()-13,FALSE)="Calendar Day",NA(),HLOOKUP("Calendar Day",Results!$6:$146,ROW()-13,FALSE))) |
|
#2
|
|||
|
|||
|
Unable to sort data in excel with cells containing if & hlookup
Figured out the problem. I was trying to sort in the wrong place--the source
data must be sorted on the other sheet. "MarcHere" wrote: I am trying to sort a column of data in excel. The cells to be sorted have formulas with multiple if and hlookups statements. I went through the sort wizard but I do not find the data sorted. Do you know of any limitations of sorting with formulas contained in the cells? Here is an example cell: =IF(HLOOKUP("Calendar Day",Results!$6:$146,ROW()-13,FALSE)="",NA(),IF(HLOOKUP("Calendar Day",Results!$6:$146,ROW()-13,FALSE)="Calendar Day",NA(),HLOOKUP("Calendar Day",Results!$6:$146,ROW()-13,FALSE))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
| sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
| how do i import data from excel, sort it then that information is. | Excel Discussion (Misc queries) | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Linear Mode
