Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Multiple entry formula

Posted on 2014-10-14
Medium Priority
97 Views
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
Question by:Seamus2626
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2

LVL 24

Expert Comment

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

Author Comment

ID: 40379557
Yes Phillip, you are correct, apologies
0

LVL 24

Accepted Solution

Phillip Burton earned 1000 total points
ID: 40379560
EE--1-.xlsx
0

LVL 24

Assisted Solution

Steve earned 1000 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

ID: 40379570
Thanks guys!
0

## Featured Post

Question has a verified solution.

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

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 article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month4 days, 21 hours left to enroll