| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code it in excel?
Hello Eric,
If your numbers are in A1:A99, then write into B1: =IF(ISBLANK(A1),"",INDEX(A1:A$99,MATCH("Z","Z"&A1: A$99,)-1)) [Enter as array formula with CTRL + SHIFT + ENTER] and copy down to B99. HTH, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
| do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
| stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Hybrid Mode
