| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Numeric in a Column?
Hi all. Could anyone help me make a vba function, that returns the
last numeric (positive or negative) cell in a column. for example in range (F6:F19): cell value F6 5 F7 10 F8 100 F9 169 F10 - F11 - .. - .. - .. - F19 - F20 =LastNumInColumn (F6:F19) OR 169 Please Note : "-" is a hypen Thanks in advance guys. Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alpha with numeric and numeric only numbers in a column | Excel Discussion (Misc queries) | |||
| find alpha in column 1 numeric column 2 | Excel Discussion (Misc queries) | |||
| How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
| How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
| Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
![Jeff[_56_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
