View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FLKULCHAR FLKULCHAR is offline
external usenet poster
 
Posts: 7
Default 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