View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
heritage1450 heritage1450 is offline
external usenet poster
 
Posts: 1
Default Sorting Coloumns that are Formula's

I have a set of data that I'm trying to sort. The data itself is coming from
a formula, but when selected the full set of data, going to Data Sort,
choosing the coloumn I want to sort on (which again is a formula) it does not
sort it correctly.

I've tried this with several different formula's that I've been using; Rank,
Index/Match combination, Vlookup, etc. It seems as though the SORT FUNCTION
does not work on cells that are formula's?