Help with counting user entered text values

D

David Leslie

Hi,

Version: Excel 2000

Situation:
In Column G, I will have testers entering in their initals.

I would like to display the tester's initals in column H of another
worksheet with the number of times that set of intals appeared in
column G on column I of the other worksheet.


The catch is that I do not have a list of the testers initals ahead of
time, so I'll need to pull them from column H.


Thanks for any and all help in advance,

David
 
D

David McRitchie

Hi David,

H10: DAL
i10: =COUNTIF(G:G,H10)

or if you don't want to see 0 if H10 is empty
I10: =IF(H10="","",COUNTIF(G:G,H32))

If your last line was a typo and you meant column G.

an alternate approach if list is not too long and you don't
know what initials are in column G ahead of time. Will
show count next to the first occurrence of the initials.
H2: =IF(CountIF(G$2:G2,G2)=1,COUNTIF(G:G,G2),"")
 
Top