| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search of first #N/A position
Hi, I have a column of downloaded data which contains names and up to a certain row it will start displaying "#N/A", how do I find the row number of the first #N/A? Please help!! thank you very much. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=518084 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search of first #N/A position
Try =MATCH(1,INDEX(ISNA(A1:A1000)+0,0),0) where your names are in A1:A1000 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=518084 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return search value, not starting position | Excel Discussion (Misc queries) | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Position of CellCursor on Screen (absolute position) | Excel Programming | |||
| Create a search Field within a worksheet to search command buttons | Excel Programming | |||
| Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
![owl527[_23_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
