Need help flagging certain entries based on cell values in row

xxHyM

New Member
Joined
Jul 4, 2018
Messages
1
Hi everyone, this is my first post so I just wanted to say thanks for all the help in the past. I've been using this forum for a while and have always been able to find the answer to my questions until now.

I performed an extraction of the data that I needed for a project and it came out as:

ID#1 | Note1 | Note2 | Condition4 | Condition2 | State1 | State3
ID#2 | Note2 | Note5 | Note7 | Condition2 | Condition5 | Condition1 | State3 | State6 | State3

Ideally, the way it should read is (for reasons explained below)

ID#1 Note1 Condition4 State1
Note2 Condition2 State3
ID#2 Note2 Condition2 State3
Note5 Conditon2 State3
Note7 Condition1 State3

What I need to do is take all the IDs and based on their condition and states, flag them or pass them.
Furthermore, one ID can have 30+ different notes but the format will always remain the same (Note1 Note2 Note3 Note4 ... etc)

There's a list of combinations of six conditions and six states put into a table.
For example, the table that states that:

Condition1 | State1 | Pass
Condition1 | State2 | Pass
Condition1 | State3 | Pass

Condition3 | State3 | Flag
Condition3 | State4 | Flag

Condition6 | State6 | Flag

If even one of the conditions and states is a flag, then the ID should be flagged as well. It would be easier to do if the table was arranged in the ideal format but since it isn't, is there a workaround or a way to maybe even turn it into the ideal format?

I hope this is clear but feel free to ask for further clarifications if required! There are > 700,000 entries in my table so this would be very useful.

I have attached an Excel file as well that may help clarify the problem.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,129,914
Messages
5,638,955
Members
417,062
Latest member
Canucks21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top