I need to analyse data and not always return the 1st instance of a lookup.
Eg. I have an account number, ID number and a domain name
There are instances where the same account and ID numbers on a row have a different domain name.
My use so far always defaults to give me the 1st instance of that combination, but I need to return all domain names, either in one cell or separate cells
Is this possible ?
Solved by Z. L. in 19 mins