[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Updating a column in Excel based on the data in other columns and rows

Posted on 2012-03-28
1
Medium Priority
?
212 Views
Last Modified: 2012-03-28
I have a file that is sorted by Column D which I am calling "Old_Id".  Column B which is called "Match Found" has a value  of "Y" set by another program.

Is there a way to update Column A "ID Match" with a "Y" if  there is a "Y" in column "B" in any row where Column "D" is the same.

(See attached file).  The results I would like a formula for are in Red Font.
Match-Found.xlsx
0
Comment
Question by:morinia
1 Comment
 
LVL 1

Accepted Solution

by:
Bob60618 earned 2000 total points
ID: 37779092
1. Sort the file - OLD_ID Lowest to highest then Match_Found Z to A (get Ys on top for each ID)
2. The formula for cell A2 is "=IF(B2="Y","Y",IF(D2=D1,IF(A1="Y","Y",""),""))"
3. Copy cell A2 down
4. Use conditional formatting to turn "Y" to red.
5. See attached
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

640 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