Have a list of 1000 names trying to sort by appearances >5. Not sure if Lookup or Hlookup?
P Pat318 Feb 17, 2010 #1 Have a list of 1000 names trying to sort by appearances >5. Not sure if Lookup or Hlookup?
G Glenn Feb 17, 2010 #2 Pat318 said: Have a list of 1000 names trying to sort by appearances >5. Not sure if Lookup or Hlookup? Click to expand... If your list is in A1:A1000, put this in B1:B1000 and sort by column B: =COUNTIF($A$1:$A$1000,A1)
Pat318 said: Have a list of 1000 names trying to sort by appearances >5. Not sure if Lookup or Hlookup? Click to expand... If your list is in A1:A1000, put this in B1:B1000 and sort by column B: =COUNTIF($A$1:$A$1000,A1)
