Creating a list
 

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?

Creating a list
 

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.

--
Biff
Microsoft Excel MVP


"Pirate" wrote in message
...
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?