VLOOKUPS

[ctomblin]

Hi. I have set up a VLOOKUP formula to find any name in a list, and it works fine with unique names, but the problem is that some names are duplicated (eg Smith J)and VLOOKUP only displays the first one that it finds. Is it possible to list all identical instances please?

 

[IML]

If you want to perform some operation on numbers associated with the names, use the sumif / countif formulas or an array type formula. If you want to return multiple text, I believe Juan Pablo's UDF found here would work. good luck
http://216.92.17.166/board/viewtopic.php?topic=19517&forum=2