| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding first number in a row
Hi,
I have a spreadsheet with numbers scattered randomly within each row e.g. Jan Feb Mar Apr May 172 200 500 20 30 40 I am trying to create a formula that will bring back the first number within each row. In the case above, the first row would bring back 172, the second row would bring back 20 and so on. I would be extremely grateful if someone would kindly let me know the formula in order for me to be able to do this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a row number | Excel Discussion (Misc queries) | |||
| Finding number less than 1 | Excel Discussion (Misc queries) | |||
| finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
| finding the right number | Excel Worksheet Functions | |||
| finding row number? | Excel Discussion (Misc queries) | |||
Threaded Mode
