#### 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
```
 0
Utf
2/26/2010 9:15:01 AM
excel.misc 78881 articles. 5 followers.

5 Replies
834 Views

Similar Articles

[PageSpeed] 9

```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
```
 0
Utf
2/26/2010 9:41:01 AM
```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
```
 0
Utf
2/26/2010 9:56:01 AM
```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
```
 0
Utf
2/26/2010 10:28:01 AM
```Thank you (ALL) very much...I used Mike H.'s approach...it seemed simplest!

FLKulchar
"FLKULCHAR" <FLKULCHAR@discussions.microsoft.com> wrote in message
news:19F06289-EA5D-4DDF-93CB-47239C135D92@microsoft.com...
>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

```
 0
Francis
2/26/2010 12:51:16 PM
```"FLKULCHAR" <FLKULCHAR@discussions.microsoft.com> wrote in message
news:19F06289-EA5D-4DDF-93CB-47239C135D92@microsoft.com...
>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

```
 0
Francis
2/26/2010 1:25:45 PM