Seamus2626
asked on
Multiple entry formula
Hi,
I need some formula that determines whether a deal number is multi product using uses the below rules
(1) if a deal number is > 1 &
(2) if the products within those deal numbers are NOT unique
then "YES"
otherwise "NO"
I have attached an example spreadsheet
Many thanks
EE.xlsx
I need some formula that determines whether a deal number is multi product using uses the below rules
(1) if a deal number is > 1 &
(2) if the products within those deal numbers are NOT unique
then "YES"
otherwise "NO"
I have attached an example spreadsheet
Many thanks
EE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
But how is that formula taking into account the product data?
Your'e only looking at the deal number?
Your'e only looking at the deal number?
ASKER
So, if the deal number is not unique, and the the products are unique, thats a "NO", otherwise a "YES"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are right ita not takng, you need to put D instead of B in the part related to countif
IF(B2>1;IF(COUNTIF(d:d;d2) >1;"YES";" NO");"NO")
IF(B2>1;IF(COUNTIF(d:d;d2)
=IF(AND(B2>1,COUNTIF(B:B,B
Regards