Excel function help

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
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare last digit in 5 cells for match 0
Print multiple booklet pages on 1 sheet 0
VBA Linest function for polynomial regression on horizontal range 0
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
Help with SUMPRODUCT & converting date to value 1
adding numbers in a column with dates 5
Cell referencing 5
INDIRECT Function 9

Top