Copy entire Row (via formula) if multiple criteria met

[SuzyQPA2]

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

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

 

[GlennUK]

You could have an extra column to make a pointer, and then reference it in your summary sheet, like this:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	GroupAcct	MemberName	Fac	Type per rate	Type per Fid	Match Type	Plan Per IBX	Plan per Fid	Match Plan	Extract pointer
2	123456	Doe, Jane	AM	single	single	TRUE	HMO High	HMO High FT	TRUE	0
3	333328	Wolf, Red Riding	AM	SINGLE	SINGLE	TRUE	DIRECTPOS	HMO HIGH FT- AMERIHEALTH	FALSE	1
4	123456	Mouse, Mickey	AM	Family	single	FALSE	HMO High	HMO High FT	TRUE	2
Sheet2

with the summary sheet fetching rows like this:

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	333328	Wolf, Red Riding	AM	SINGLE	SINGLE	TRUE	DIRECTPOS	HMO HIGH FT- AMERIHEALTH	FALSE
3	123456	Mouse, Mickey	AM	Family	single	FALSE	HMO High	HMO High FT	TRUE
4
Sheet1

 

[Peter_SSs]

My suggestion is similar in concept. Formulas a little different.

Sheet2
If I have understood your requirements correctly then you could use these formulas in F2 and I2 (copied down) instead of the formulas you currently have. If I have that wrong then keep your current formulas but the rest of my suggestion should still hold.

J1 is blank or houses a 0
J2 copied down

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	GroupAcct	MemberName	Fac	Type per rate	Type per Fid	Match Type	Plan Per IBX	Plan per Fid	Match Plan		2
2	123456	Doe, Jane	AM	single	single	TRUE	HMO High	HMO High FT	TRUE	0
3	333328	Wolf, Red Riding	AM	SINGLE	SINGLE	TRUE	DIRECTPOS	HMO HIGH FT- AMERIHEALTH	FALSE	1
4	123456	Mouse, Mickey	AM	Family	single	FALSE	HMO High	HMO High FT	TRUE	2
5
Sheet2

Sheet1
J1 is blank or houses a 0
J2 copied down.
A2 copied across to column I and then A2:I2 copied down.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	GroupAcct	MemberName	Fac	Type per rate	Type per Fid	Match Type	Plan Per IBX	Plan per Fid	Match Plan
2	333328	Wolf, Red Riding	AM	SINGLE	SINGLE	TRUE	DIRECTPOS	HMO HIGH FT- AMERIHEALTH	FALSE	1
3	123456	Mouse, Mickey	AM	Family	single	FALSE	HMO High	HMO High FT	TRUE	2
4
Sheet1

 

[SuzyQPA2]

Peter,
I would either leave the True/False columns in or have the differences highlighted with a conditional formula. That way there is a summary page with the differences and a detail page with all data showing differences.

 

[Peter_SSs]

Peter,
I would either leave the True/False columns in or have the differences highlighted with a conditional formula. That way there is a summary page with the differences and a detail page with all data showing differences.

I was not suggesting that you remove the True/False columns. I was just suggesting simpler formulas to produce the True/False values in those columns.

Did you try either of the suggestions for producing the summary page? Did they produce the desired result.