Prev: Excel files take long time to open
Next: HELP!! Formula with different conditions
From: Pat318 on 17 Feb 2010 11:21
Have a list of 1000 names trying to sort by appearances >5.
Not sure if Lookup or Hlookup?
From: Glenn on 17 Feb 2010 11:29
Pat318 wrote:
> Have a list of 1000 names trying to sort by appearances >5.
> Not sure if Lookup or Hlookup?

If your list is in A1:A1000, put this in B1:B1000 and sort by column B:

=COUNTIF($A$1:$A$1000,A1)
 | 
Pages: 1
Prev: Excel files take long time to open
Next: HELP!! Formula with different conditions