Forum Discussion
Excel Help
I was sent a contact information list & the same name is listed multiple times with different emails. (Each person has more than 1 email address.) If we upload into our system as is, it creates a sep...
=IFERROR(INDEX($B$2:$B$15,SMALL(IF($A$2:$A$15=$D2,ROW($A$2:$A$15)-1),COLUMN(A$1))),"")An alternative with e.g. Excel 2013 could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
The formula is in cell E2 and then filled across range E2:I6 in the example.