Hi,
Assuming your data is arranged in range A1:B7 like this
Ashish 100
Sanjay 200
Pongal 300
Ashish 400
Rajesh 500
Suresh 600
Ashish 700
In cell A10 enter any of the names mentioned in range A1:A7. In cell B10,
enter the following array formula (Ctrl+Shift+Enter)
=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2))
Copy this formula down.
Please let me know if you need any more clarifications on this
(
[email protected]). Will be more then willing to help you
Regards,
Ashish Mathur