Help please

[cccc]

I have this project to do for my job. It is not easy for me because i do not
know how to do it. The project is next: in several colomns will be the names
A B C
Bob W. Rosa A. George N.
Michael J. Bob W. Bob W.
Jack K. Rosa A. Jack K.
Now in column D i need to have some kind of formula that will tell me for
example
3-5 Bob W. repeated name
6-10 Jack W., Jordan K. etc repeated
11+ Such and such repeated name
That is project involving letters and numbers mixed or letters only or
numbers only.

I never thought that this will be needed but i really apriciate enything

 

[Brad]

One solution in column D
=COUNTIF(A1:C3,"Bob W")
will provide the answer of three
or
Having a help column in D
Where D1 = Bob W
in column E
=COUNTIF(A1:C3,D1)
will provide the answer of three

In either case you can change range of a1:c3 - to fit you needs......

 

[cccc]

I mean there will be a lot of names and numbers, that i can not actually
track them. So i was asking if it is posibile that some kind of formula will
bring forward names that are repeating, or lets say change the color of
fonts. EX. 3-5 will turn to orange, 6-10 blue and 11+ red if you know what i
mean

Thank you for your time and your help!!

 

[Brad]

What you are asking for is found under conditional formating - the sequence
of steps is different depending what version of Excel you are in..

But the equation you want to enter is
=and(COUNTIF($C$2:$C$7,C2)>=3,COUNTIF($C$2:$C$7,C2)<=5)

This assumes that the string of values to be counted is in column C rows 2
through 7.

and change the color as you like, I remember that Excel 2003 has three
conditional format levels, not sure what the the 2007 limit is. If you need
more than four colors, (the main color + the three conditional formats) VBA
macros can help....