Hi all,
One of my colleagues has asked me this question and I'm stuck for an answer
He's got column A with a list of unique numbers - invoice numbers and column B has a list of company names.
He wants in another sheet to return all of the unique numbers from column A that have a specific value from Column B.
I'd use a pivot table but he doesn't want one, and it's a shared sheet which is causing issues.
Countif will only give him a number and he wants the specific value!
Any help appreciated
Thanks
Matt
One of my colleagues has asked me this question and I'm stuck for an answer
He's got column A with a list of unique numbers - invoice numbers and column B has a list of company names.
He wants in another sheet to return all of the unique numbers from column A that have a specific value from Column B.
I'd use a pivot table but he doesn't want one, and it's a shared sheet which is causing issues.
Countif will only give him a number and he wants the specific value!
Any help appreciated
Thanks
Matt