Searching for a rows that contain a value in one column in Excel

Question

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?

try http://superuser.com/questions/201434/getting-the-value-in-one-column-from-a-formula-on-another-column-in-excel http://superuser.com/questions/81498/excel-find-items-in-one-column-that-are-not-in-another-column — Sathyajith Bhat, Jul 31 '11 at 14:14

score 2 · Accepted Answer · edited Aug 01 '11 at 07:04

2

Put this in D1:

=IF(B1="Y",A1)

edited Aug 01 '11 at 07:04

Gaff

18,569
15
57
68

answered Jul 31 '11 at 17:40

soandos

24,206
28
102
134

Searching for a rows that contain a value in one column in Excel

1 Answers1