function for repeated cells
Hi,
if b2 is the start of your data then use, from c2
=countif($b$2:$b$XXX,b2)-1 where xxx is the bottom row
there are variants but this should tell you beside every value how many
times it occurs elsewhere
Cheers
Dazza
------------------------------------------------------------
Please register if this has been helpful.
"Haz" wrote:
hi
I have a spreedsheet that has cells that are repeated amongst others I want
to write a function that will identify these.
if column A has this data in it how can I pick up the identical cell in
Column B
DMM9844
DMM9844 1 - this what I want in col B.
DMM9756
DMM6456 1
DMM6747
DMM3463
DMM4574
i think it may be a sumif function but i can't get it to work. Can anybody
help?
Thanks
|