Solved

Multiple entry formula

Posted on 2014-10-14
5
93 Views
Last Modified: 2014-10-14
Hi,

I have a data where i have 2/3 deal numbers and i need to extract data from them on a row by row basis

I have attached a file as i feel it will be a lot easier to understand. The cells highlighted yellow are the ones i need populating

Many thanks
EE.xlsx
0
Comment
Question by:Seamus2626
  • 2
  • 2
5 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40379555
I'm presuming that row 5 is wrong - there doesn't seem to be a different country with 198073.
0
 

Author Comment

by:Seamus2626
ID: 40379557
Yes Phillip, you are correct, apologies
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 250 total points
ID: 40379560
Please find attached.
EE--1-.xlsx
0
 
LVL 24

Assisted Solution

by:Steve
Steve earned 250 total points
ID: 40379561
The following formula shoud do you...

in column 'D': =IF(COUNTIFS(B:B,B2)=1,"Yes","No")
in column 'E': =IF(D2="Yes","No","Yes")
in column 'F': =IF(COUNTIFS(B:B,B2,C:C,C2)=COUNTIFS(B:B,B2),"Yes","No")
in column 'G': =IF(F2="Yes","No","Yes")

See attached for application...
U--EE.xlsx
0
 

Author Closing Comment

by:Seamus2626
ID: 40379570
Thanks guys!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now