•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Gather unique names to show multiple columns as well.
G'day team.
I am stuck at what should be a simple issue but my brain has gone away on holidays it would seem. I have a csv of events of the previous month which has multiple ID's (col A)that match Suburbs (col B) and postcodes (zip codes) (col C). I am attempting to sort the unique ID numbers to show the matching Suburb and Post Code. I have tried XLOOKUP, UNQUIE, GROUPBY and other Youtube hints but nothing working. I know it will be something simple but my brain is just not working the problem today. The data will be joined with Lat & Long coordinates for inclusion into a GIS report. Any help greatly appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site