Multiple name appearances

  • Thread starter Thread starter Pat318
  • Start date Start date
P

Pat318

Have a list of 1000 names trying to sort by appearances >5.
Not sure if Lookup or Hlookup?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I look up which column a value is in? 7
Question regarding HLookup (unique values) 7
Hlookup, range_lookup parameter 1
Hlookup a value in a column and display the data 12 rows below. 3
Lookup & named cells 2
OFFSET and LOOKUP Error 1
hlookup value within a range 4
vlookup 3

Back
Top