| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find first numer in a Column
In a spreadsheet Column H is filled randomly
with numbers and blanks from Row 13 down. I want to find the first number i.e. occurring in the lowest row number in the Column. Preferably found by worksheet formula, failing that I could use a macro. Many thanks for any solutions. -- Occasionally stumped |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find first numer in a Column
=INDEX(H13:H200,MATCH(TRUE,ISNUMBER(H13:H200),0))
which must be confirmed with control+shift+enter, not just enter. Two-Canucks wrote: In a spreadsheet Column H is filled randomly with numbers and blanks from Row 13 down. I want to find the first number i.e. occurring in the lowest row number in the Column. Preferably found by worksheet formula, failing that I could use a macro. Many thanks for any solutions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
Linear Mode
