Sure, No formula in C1 just the filtered title "Products".

C2:C2042 contain various product names
D2:D2042 contain various product values
both are on the same worksheet. Sheet 1 "ProdData"

"Domenic" wrote:

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