Hello everyone,
I've trying to set up a formula, which i thought would be easy but seem to be stuck.
My spreadsheet has two worksheets House List & Brandcount
House List has the account number in column C and the account number in the Brandcount is in column A.
In the Brandcount worksheet in column B is a list of brands purchased (Brand 1, Brand 2, Brand 3, Brand 4, Brand 5)
What i wanted to do is in House List is in column F count the brands purchased by each account number, is:
Account 12345 , 3 brands
I've tried using a combination of countif and vlookup but not getting far.
Can someone point me in the right direction.
Thanks
I've trying to set up a formula, which i thought would be easy but seem to be stuck.
My spreadsheet has two worksheets House List & Brandcount
House List has the account number in column C and the account number in the Brandcount is in column A.
In the Brandcount worksheet in column B is a list of brands purchased (Brand 1, Brand 2, Brand 3, Brand 4, Brand 5)
What i wanted to do is in House List is in column F count the brands purchased by each account number, is:
Account 12345 , 3 brands
I've tried using a combination of countif and vlookup but not getting far.
Can someone point me in the right direction.
Thanks