LaFlame
10-08-2007 23:18:23
Im having problems displaying the duplicate entries in row B. As you see, there are some duplicates in B. But i dont know how to display the amount of duplicates i have(just want to show how many duplicates i have or which entries are duplicates)...can anyone help me out?
A
IMAGE
IMAGE
IMAGE
IMAGE
IMAGE
IMAGE
B
FULL-SBC0001
FULL-SBC0002
FULL-SBC0003
MODD-SBC0001
MODD-SBC0002
FM - 0003
C
E
D
0
0
0
0
0
0
E
@sbc001
@sbc001
@sbc001
@sbc001
@sbc001
@sbc001
H
2
2
2
2
2
2
doylnea
11-08-2007 05:56:07
Google "Count Duplicates Excel"
nobody2000
12-08-2007 00:17:46
[code18ed1d3781e]do something like =if a=b:x, then count(a:x)
I'm not totally sure, but play around with those, and search around on yahoo/google.[/code18ed1d3781e]