Solved

Multiple entry formula

Posted on 2014-10-14
6
56 Views
Last Modified: 2014-10-14
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
Comment
Question by:Seamus2626
  • 2
  • 2
  • 2
6 Comments
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 250 total points
ID: 40379911
Here is the formula:

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

Expert Comment

by:Rgonzo1971
ID: 40379922
OR

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

Regards
0
 

Author Comment

by:Seamus2626
ID: 40379933
But how is that formula taking into account the product data?

Your'e only looking at the deal number?
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:Seamus2626
ID: 40379944
So, if the deal number is not unique, and the the products are unique, thats a "NO", otherwise a "YES"
0
 
LVL 49

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 250 total points
ID: 40379955
Hi,

pls try

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

Regards
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40379958
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question