Hi,
I have columns & rows of data
I have inserted Columns where i am comparing data and get the result True/False.
What i would like is a formula that pulls a row that has any false in it to a summary worksheet (say Sheet1)
Thanks any help appreciated.
I would prefer a formula if possible to do by formula.
eg
I have columns & rows of data
I have inserted Columns where i am comparing data and get the result True/False.
What i would like is a formula that pulls a row that has any false in it to a summary worksheet (say Sheet1)
Thanks any help appreciated.
I would prefer a formula if possible to do by formula.
eg
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | GroupAcct | MemberName | Fac | Type per rate | Type per Fid | Match Type | Plan Per IBX | Plan per Fid | Match Plan | ||
2 | 123456 | Doe, Jane | AM | single | single | TRUE | HMO High | HMO High FT | TRUE | ||
3 | 333328 | Wolf, Red Riding | AM | SINGLE | SINGLE | TRUE | DIRECTPOS | HMO HIGH FT- AMERIHEALTH | FALSE | ||
4 | 123456 | Mouse, Mickey | AM | Family | single | FALSE | HMO High | HMO High FT | TRUE | ||
AM-IBX |