Hello,
I have spent hours looking for a solution to this and have gathered I should use Index/Match, but I can't figure it out.
I have a set of unique names in a spreadsheet which are listed over time.
In other words, the names can occur in any column or row.
I would like to extract every unique name based on the first name.
Example Book#Sheet1!A1_K5.png

Any help would be greatly appreciated! Thank you!