I have several columns in a spreadsheet in Excel and need to find the rows that contain the value Y in column B (CWI in example below), then print out the value of another column (e.g. Column A; Job Number in the example below) so then I can relate this to some paperwork that I need to extract data from. My spreadsheet looks like this:
Job Number | CWI | LI
-----------+-----+---
1114 | Y | N
-----------+-----+---
1115 | N | N
-----------+-----+---
1116 | Y | Y
Is there some kind of script/formula I can use to iterate through all the rows and search for a value in column CWI then list the Job Number again in another column?