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
|