Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Creating a Drop Down List from a List in another worksheet | Excel Discussion (Misc queries) | |||
Creating a Detailed List from a Summary List | Excel Worksheet Functions | |||
Creating A Breakout List from a Summary List | Excel Discussion (Misc queries) | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |