remove numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

good day,
What I would like to do are, if I get 0,35,35 it should give 0 and 35.
if I get 20,26,20 it should give 20
and 26
if I get 20,21,26 it should give
20,21 and 26

Thanks.
 
IF the 3 numbers are in separate cells (using row 3 for example) and you
actually want an output like "1, 2, 3" in a single cell then this following
formula in some cell other than A3, B3 or C3 would do it (and yes, it's one
huge, long, ugly formula)

=IF(A3=MIN(A3:C3), A3,IF(B3=MIN(A3:C3), B3,IF(C3=MIN(A3:C3),C3,"")))
&IF(OR(B3=MIN(A3:C3),B3=MAX(A3:C3)),"",IF(OR(B3=A3,B3=C3),"",", " & B3))&
IF(C3=MAX(A3:C3),IF(C3=MIN(A3:C3),"",", " & C3),IF(B3=MAX(A3:C3),", " &
B3,IF(A3=MAX(A3:C3),", " & A3,"")))
 
Another IF;
And I apologize for the long, harsh formulas - I'm not the best when it
comes to these kinds of things and perhaps someone else will come up with a
less complex solution. But...

if the 3 numbers are in 3 cells, again using A3, B3 and C3 for them, then
these formulas in another group of 3 (D3, E3 and F3 in these examples) would
show the list as you want:
in D3:
=IF(A3=MIN(A3:C3), A3,IF(B3=MIN(A3:C3), B3,IF(C3=MIN(A3:C3),C3,"")))

in E3:
=IF(OR(B3=MIN(A3:C3),B3=MAX(A3:C3)),IF(C3=MAX(A3:C3),IF(C3=MIN(A3:C3),"",
C3),IF(B3=MAX(A3:C3),B3,IF(A3=MAX(A3:C3), A3,""))),IF(OR(B3=A3,B3=C3),"", B3))

and in F3:
=IF(C3=MAX(A3:C3),IF(C3=MIN(A3:C3),"",IF(C3<>E3,C3,"")),IF(B3=MAX(A3:C3),IF(B3=E3,"",B3),IF(A3=MAX(A3:C3),IF(A3<>E3,A3,""))))
 
Back
Top