Prev: Time
Next: Pivot Table Change to US Date Format - Why?
From: Reepo on 22 Apr 2010 16:34
I know how to find duplicated records, but my problem is that I need to know
where does the value is repeated. Home my ASCII art illustrates what I need.
A B C
1 - a 2x - A4
2 - b 1x - A6
3 - c 1x - 0
4 - a 2x - A1
5 - d 1x - 0
6 - b 2x - A2
7 - e 1x - 0

A show the values
B show how many times the value is repeated
C Shows the cell, or cells where the exactle value is.
Im not sure if its posible to do so, but I had to ask.
Thanks.
 | 
Pages: 1
Prev: Time
Next: Pivot Table Change to US Date Format - Why?