Forum Discussion
Filter mulitple rows by matching data in one column
I have an grid of data where we have many companies listed many times for different transactions all of which have a location of the transaction. I woud like to find a list of all companies who have ...
JulianpIDG Since you mention "many companies listed", you may consider PowerQuery (if you're not a Mac). Alternatively, if you are an MS365 subscriber, you can do it in a few steps with UNIQUE, FILTER. Working examples in the attached workbook.