Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 83
  • Last Modified:

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
0
Seamus2626
Asked:
Seamus2626
  • 2
  • 2
  • 2
2 Solutions
 
Haris DjulicCommented:
Here is the formula:

=+IF(B2>1;IF(COUNTIF(B:B;B2)>1;"YES";"NO");"NO")
0
 
Rgonzo1971Commented:
OR

=IF(AND(B2>1,COUNTIF(B:B,B2)>1),"YES","NO")

Regards
0
 
Seamus2626Author Commented:
But how is that formula taking into account the product data?

Your'e only looking at the deal number?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Seamus2626Author Commented:
So, if the deal number is not unique, and the the products are unique, thats a "NO", otherwise a "YES"
0
 
Rgonzo1971Commented:
Hi,

pls try

=IF(COUNTIFS(B:B,B2,D:D,D2)<>COUNTIFS(B:B,B2),"Yes","No")

Regards
0
 
Haris DjulicCommented:
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")
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now