Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Cross"-Auto filling: consecutive columns into rows | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |