Hi All:
This is just a sample of the database.
What I need to do is extract only the records that don't have Y for Yes. Therefore, the desired output should only return the records that have 'Missing' or lets say something "No". Can someone please tell me how this can be done in excel. The database is huge so it is tough to filter column by column.
Thanks in advance for your help.
This is just a sample of the database.
Sent Reports data upload status.XLS | |||||||
---|---|---|---|---|---|---|---|
C | D | E | F | G | |||
1 | BRANCHNAME | 2006-P9W3 | 2006-P9W2 | 2006-P9W1 | 2006-P8W4 | ||
2 | Birmingham | Y | Y | Y | Y | ||
3 | Boston | Y | Y | Y | Y | ||
4 | Buffalo | Y | Y | Y | Y | ||
5 | Calgary | MISSING | Y | Y | Y | ||
6 | Dubai | Y | Y | Y | Y | ||
7 | Dusseldorf | Y | MISSING | Y | Y | ||
8 | Edmonton | MISSING | Y | Y | Y | ||
9 | Fargo | MISSING | Y | MISSING | Y | ||
10 | FortMeyers | MISSING | Y | Y | Y | ||
11 | Frankfurt | MISSING | Y | Y | MISSING | ||
12 | Fresno | Y | Y | Y | Y | ||
13 | GrandRapids | Y | Y | Y | Y | ||
14 | Halifax/Moncton | Y | Y | Y | Y | ||
15 | Hamburg | Y | Y | Y | Y | ||
16 | Houston | Y | Y | Y | Y | ||
Status |
What I need to do is extract only the records that don't have Y for Yes. Therefore, the desired output should only return the records that have 'Missing' or lets say something "No". Can someone please tell me how this can be done in excel. The database is huge so it is tough to filter column by column.
Thanks in advance for your help.