Creating a list

P

Pirate

I have a spreadsheet with numbers and text spread out across columns. I need
to search across the columns by row and return to the "A" column the first
value found either number or text. Is there such a formula?
 
T

T. Valko

Try this array formula** :

=IF(COUNTA(B1:J1),INDEX(B1:J1,MATCH(TRUE,B1:J1<>"",0)),"")

Copy down as needed

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
 
Top