FINDING "EQUALITY" within 3 consecutive columns
 

I have 3 consecutive columns, A,B, & C with various numbers within
each...also there are probably 1500 rows.

How do I find the rows where each of the three numbers within that row are
equal?

EXAMPLE:

A B C

1 128 158 188
2 127 128 128
3 211 188 170
4 199 196 165
5 165 165 165
6 166 166 167
7 179 185 196
8 169 165 166
9 111 114 185
10 117 185 165

OBVIOUSLY ROW 5 IS THE ANSWER, BUT EACH NUMBER IS FORMATTED TO NO DECIMAL
PLACES, ALTHOUGH EACH OF THE NUMBERS ARE ARITHEMETIC AVERAGES WITH
INNUMERABLE DECIMAL PLACES!

Thank you,

FLKulchar

FINDING "EQUALITY" within 3 consecutive columns
 

Hi,

This will return 1 for all equal or 0 for not equal. Put it in D1 and double
click the fill handle to make it fill down

=(INT(A1)=INT(B1))*(INT(B1)=INT(C1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"FLKULCHAR" wrote:

I have 3 consecutive columns, A,B, & C with various numbers within
each...also there are probably 1500 rows.

How do I find the rows where each of the three numbers within that row are
equal?

EXAMPLE:

A B C

1 128 158 188
2 127 128 128
3 211 188 170
4 199 196 165
5 165 165 165
6 166 166 167
7 179 185 196
8 169 165 166
9 111 114 185
10 117 185 165

OBVIOUSLY ROW 5 IS THE ANSWER, BUT EACH NUMBER IS FORMATTED TO NO DECIMAL
PLACES, ALTHOUGH EACH OF THE NUMBERS ARE ARITHEMETIC AVERAGES WITH
INNUMERABLE DECIMAL PLACES!

Thank you,

FLKulchar

FINDING "EQUALITY" within 3 consecutive columns
 

Try one of below formulas

=IF(AND(A2=C2,A2=E2),"Match","Mismatch")
=IF(AND(round(A2,0)=round(C2,0),round(A2,0)=round( E2,0)),"Match","Mismatch")

Regards,
Pritesh


"FLKULCHAR" wrote:

I have 3 consecutive columns, A,B, & C with various numbers within
each...also there are probably 1500 rows.

How do I find the rows where each of the three numbers within that row are
equal?

EXAMPLE:

A B C

1 128 158 188
2 127 128 128
3 211 188 170
4 199 196 165
5 165 165 165
6 166 166 167
7 179 185 196
8 169 165 166
9 111 114 185
10 117 185 165

OBVIOUSLY ROW 5 IS THE ANSWER, BUT EACH NUMBER IS FORMATTED TO NO DECIMAL
PLACES, ALTHOUGH EACH OF THE NUMBERS ARE ARITHEMETIC AVERAGES WITH
INNUMERABLE DECIMAL PLACES!

Thank you,

FLKulchar

FINDING "EQUALITY" within 3 consecutive columns
 

If you have only one set of 3 equal values - in cell D1 type:
=MATCH(TRUE,INDEX(A1:A1500&B1:B1500&C1:C1500=REPT( A1:A1500,3),),)--
in order to return 5 (in your case)
Micky


"FLKULCHAR" wrote:

I have 3 consecutive columns, A,B, & C with various numbers within
each...also there are probably 1500 rows.

How do I find the rows where each of the three numbers within that row are
equal?

EXAMPLE:

A B C

1 128 158 188
2 127 128 128
3 211 188 170
4 199 196 165
5 165 165 165
6 166 166 167
7 179 185 196
8 169 165 166
9 111 114 185
10 117 185 165

OBVIOUSLY ROW 5 IS THE ANSWER, BUT EACH NUMBER IS FORMATTED TO NO DECIMAL
PLACES, ALTHOUGH EACH OF THE NUMBERS ARE ARITHEMETIC AVERAGES WITH
INNUMERABLE DECIMAL PLACES!

Thank you,

FLKulchar

FINDING "EQUALITY" within 3 consecutive columns
 

Thank you (ALL) very much...I used Mike H.'s approach...it seemed simplest!

FLKulchar
"FLKULCHAR" wrote in message
...
I have 3 consecutive columns, A,B, & C with various numbers within
each...also there are probably 1500 rows.

How do I find the rows where each of the three numbers within that row are
equal?

EXAMPLE:

A B C

1 128 158 188
2 127 128 128
3 211 188 170
4 199 196 165
5 165 165 165
6 166 166 167
7 179 185 196
8 169 165 166
9 111 114 185
10 117 185 165

OBVIOUSLY ROW 5 IS THE ANSWER, BUT EACH NUMBER IS FORMATTED TO NO DECIMAL
PLACES, ALTHOUGH EACH OF THE NUMBERS ARE ARITHEMETIC AVERAGES WITH
INNUMERABLE DECIMAL PLACES!

Thank you,

FLKulchar

FINDING "EQUALITY" within 3 consecutive columns
 

"FLKULCHAR" wrote in message
...
I have 3 consecutive columns, A,B, & C with various numbers within
each...also there are probably 1500 rows.

How do I find the rows where each of the three numbers within that row are
equal?

EXAMPLE:

A B C

1 128 158 188
2 127 128 128
3 211 188 170
4 199 196 165
5 165 165 165
6 166 166 167
7 179 185 196
8 169 165 166
9 111 114 185
10 117 185 165

OBVIOUSLY ROW 5 IS THE ANSWER, BUT EACH NUMBER IS FORMATTED TO NO DECIMAL
PLACES, ALTHOUGH EACH OF THE NUMBERS ARE ARITHEMETIC AVERAGES WITH
INNUMERABLE DECIMAL PLACES!

Thank you,

FLKulchar