Hello All,
I have the following formula
=IF(COUNTIF($A$1:A2,A2)=1,COUNTIF(A:A,A2),"")
What it does is count the duplicates in the A column and returns a result of how many duplicates there are. I'm using this as I have a spreadsheet full of basket ID'd from on-line purchases and need to know volume per basket which is shown by the amount of times a basket ID is duplicated (once per product).
In column E it states whether a basket is a "club" member or "not".
I want to add to the above formula so it only checks baskets that are "club" and not baskets that aren't.
Is there anyway anyone could show me what the addition is? I tried a AND function but it wouldn't work. I'm relatively new to excel so your help is greatly appreciated.
Thanks,
Joe.
I have the following formula
=IF(COUNTIF($A$1:A2,A2)=1,COUNTIF(A:A,A2),"")
What it does is count the duplicates in the A column and returns a result of how many duplicates there are. I'm using this as I have a spreadsheet full of basket ID'd from on-line purchases and need to know volume per basket which is shown by the amount of times a basket ID is duplicated (once per product).
In column E it states whether a basket is a "club" member or "not".
I want to add to the above formula so it only checks baskets that are "club" and not baskets that aren't.
Is there anyway anyone could show me what the addition is? I tried a AND function but it wouldn't work. I'm relatively new to excel so your help is greatly appreciated.
Thanks,
Joe.