Nested If

[starnold]

I am trying to compare data across columns and tell me if they results match

Col1 Col2 Col3 Col4
1 1 2 1
1 1 1 1

What I want to see is a TRUE or FALSE to say the data in all columns match

First row would be false as Col3 doesn't match with the others but the 2nd row would match

 

[-Wayner-]

=IF(AND(A2=B2,B2=C2,C2=D2),"True","False")

Would Work assuming you always have 4 columns (if not change the 4) Assumes data is in columns A - D and starts in row 2.

EDIT: Changed that, first one wouldn't have worked :/

 

[dcofer]

Are there always only 4 columns?

If so, this formula is a little long, but will work.

=IF(A1=B1,IF(B1=C1,IF(C1=D1,"True","False")))

There are others here who can probably provide a better and shorter solution.

Hope this helped.

---dave

 

[jasonb75]

Have a look at this thread, several options there that may be suitable for you.

http://www.mrexcel.com/forum/showthread.php?p=2393789

 

[Sandeep Warrier]

If they are all numbers then try

Excel Workbook
	A	B	C	D	E
1	1	1	2	1	FALSE
2	1	1	1	1	TRUE
Sheet1

Excel 2003

Cell Formulas
Range	Formula
E1	=COUNTIF(A1:D1,A1)=COUNT(A1:D1)

 

[starnold]

Is there a way to say TRUE if any of the columns match the first column?

So using the below example only the first second row would be TRUE as Col2 matches Col1

Col1 Col2 Col3
A A B
A B C

 

[jasonb75]

How about

Excel Workbook
	A	B	C	D	E
1	A	A	B		TRUE
2	A	B	C		FALSE
Sheet

 

[scottylad2]

Is there a way to say TRUE if any of the columns match the first column?

So using the below example only the first second row would be TRUE as Col2 matches Col1

Col1 Col2 Col3
A A B
A B C

Are you mixing up rows and columns in your question? Col One has A in row 1 and 2, Col 2 Has A in row 1 and B in row 2 so Row 2 in Col 1 matches Row 1 ini col 2, and in Col 2 Row 2 the B should surely match col 3 row 1? both are B using the same logic?

 

[scottylad2]

Excel Workbook
	M	N	O	P
105	a	b	c	TRUE
106	a	a	b	FALSE
Course Dates

Excel Workbook
	P
106	FALSE
Course Dates

 

[Sandeep Warrier]

Also

Excel Workbook
	A	B	C	D
1	A	A	B	TRUE
2	A	B	C	FALSE
Sheet1

Excel 2003

Cell Formulas
Range	Formula
D1	=COUNTIF(A1:C1,A1)>1