unique records formula
Can you post the formula contained in C1? Also, can you confirm which
cells and worksheet contain the data, and which cells and worksheet
contain the formulas?
In article ,
MP wrote:
I changed the last instance and could not get the fomula to work properly.
Still list the duplicate values.
I appreciate your help!
"Domenic" wrote:
Sorry, my mistake! Try replacing the last instance of...
ROWS($C$2:C2)
with
1
Hope this helps!
In article ,
MP wrote:
Thanks for the reply however i could not get the formula to work. Maybe i
missed something trying to adjust the formula per the data in my table.
=IF(ROWS($C$2:C2)<=$C$1,LARGE(IF(ISNA(MATCH($D$2:$ D$2042,$C$1:C1,0)),IF(SU
BTOT
AL(2,OFFSET($D$2:$D$2042,ROW($D$2:$D$2042)-ROW($D$2),,1)),$D$2:$D$2042)),R
OWS(
$C$2:C2)),"")
Column C: Product Name
Column D: Value
Thanks for your assistance
|