Excel function help

  • Thread starter Thread starter topdog
  • Start date Start date
T

topdog

Hi, is there a way to do this on a worksheet?


A1.....A5 have numbers. Only 1 might have text in them. Is there a
way to print the text in A6 if one of them has text?

1,2,3,4,5 A6: ""

1,text,3,4,5 A6: text
1,2,3,4,text A6: text
 
This array formula will do it

=IF(COUNT(A1:A5)=5,"",INDEX(A1:A5,MATCH(TRUE,ISTEXT(A1:A5),0)))

entered with ctrl + shift & enter

Note that it will pick up the first text value in the range
 
Back
Top