Formula for Different Values

  • Thread starter Thread starter JD
  • Start date Start date
J

JD

I have a list of clients in Column A. I would like to
create a formula that tells me how many different clients
there are. So if I have Rodriguez twice in the column I
only wanted it counted once. I do realize that a spelling
difference or even an extra space will count as 2. I will
make sure that does not happen. Any help on this?
 
Hi JD!

See:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique

Chip has all sorts of formulas for handling these unique / duplicate
problems.

You might also consider looking at Pivot tables which are designed for just
this sort of problem.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
What you need to do is if you have a list and you want to count ho
often each client is listed is to do the following.


Let's say your list of clients is in cells B1 through B100. Let's sa
"Smith" is in there 5 times and Jones is in there 4 times.

Then have in A105 "Smith" In B105 put this formula:
=COUNTIF($B$1:$B$100,$A105)

In A106 put "Jones" and in B106 put:
=COUNTIF($B$1:$B$100,$A106)

whatever you have in A from row 105 on down will be counted
 
Back
Top