try this

Names are in Col A and Amounts are in Col B

using advance filter take out unique names in Col A paste it in Col C

C2 you have names in D2 put this formula and drag it down

=IF(ISERROR((INDEX($B$1:$B$100,SMALL(IF($A$1:$A$10 0=$C$2,ROW($A$1:$A
$100)),ROW(1:1)),0))),"",INDEX($B$1:$B$100,SMALL(I F($A$1:$A$100=$C
$2,ROW($A$1:$A$100)),ROW(1:1)),0))

Use Ctrl + shift + enter ( array formula )

To know the highest and lowest amount use this forumla

In Cell F2 put this formula to know the Highest value
=MAX(IF(--(A2:A100=C2)*(B2:B100)=0,"",(A2:A100=C2)*(B2:B100) )) ( use
ctrl + shift + enter once u enter the formula )

To know the lowest value use this formula
=MIN(IF(--(A2:A100=C2)*(B2:B100)=0,"",(A2:A100=C2)*(B2:B100) )) ( use
ctrl + shift + enter once u enter the formula )











On Oct 15, 12:55*pm, Sandeep Jangra
wrote:
D'all,
I have a two column (Name and Amount) list with repeated values, Plz help me
about these ...
1. I want to look up all the repeated values against a single name
2. lookup heightest and lowest amount against a single name.

Sandeep Jangra