Is there a way to count how many of each entry I have in a column?

  • Thread starter Thread starter odin
  • Start date Start date
O

odin

Can someone help me? I opened a spreadsheet of servers, users, and
software versions and need to generate a list that only tells how many
users are on each server.

Basically, I want to generate a list of how many server entries there are,
since the servers are next to every user that should tell me how me how many
users are on each server.

For example:

server a
server a
server b

would become

server a 2
server b 1


Thanks.

Ed
 
Hi Ed,

Assuming that your list is in Column A, enter your list of servers in
another column, say Column C, enter the following formula in D1 and copy
down:

=COUNTIF($A$1:$A$3,C1)

Adjust the range accordingly.

Hope this helps!
 
Okay, I think I have the idea. The only thing now is I need just the list
of individual servers. The list I have in Column A has many duplicates. Is
there a way to create a list of the servers without duplicates for Column C?
 
Nevermind that last question. I figured it out. Now I have to try the
formula. I'll let you know how it works out.

Thanks.

Ed
 
Domenic,

You are the man!! Thanks a million!


odin said:
Okay, I think I have the idea. The only thing now is I need just the list
of individual servers. The list I have in Column A has many duplicates.
Is there a way to create a list of the servers without duplicates for
Column C?
Click to expand...
 
Back
Top