Try...
B8, copied down:
=COUNTIF($A$1:$A$7,A8)
Hope this helps!
sudeepd12 Wrote:
Thanks for the command. It gives the number of distinctive or unique
values in the range.
Could you suggest a way to get the count of each of the repetitive
values without having to specify each using the COUNTIF command.
For instance
-----------
jbushnel --A1
jbreen
jthayer
rrobinson
ajagmag
jthayer
jbushnel --A7
-----------
I am looking for a formula which will split the results as:
A8-- jbushnell 2--B8
jthayer 2
rrobinson 1
ajagmag 1
jbreen 1
Is this possible?Please let me know. Thanks for your time.
Regards,
Sudeep
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=379169