# Need help flagging certain entries based on cell values in row

#### xxHyM

##### New Member
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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

1,128,101
Messages
5,628,696
Members
416,333
Latest member
Time2Learn

### 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.

### Which adblocker are you using?

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

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