| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count first occurance of text
.. how do I return the 2nd instance?
Put this in B2, array-enter, ie press CTRL+SHIFT+ENTER to confirm: =INDEX(A:A,SMALL(IF(ISTEXT(A$2:A$25),ROW(A$2:A$25) ),ROWS($1:1))) Copy down as far as required. B2 returns the 1st TEXT data in A2 down, B3 returns the 2nd TEXT data (2nd instance), and so on. #NUM! will signal the exhaustion of all TEXT data -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurance of a leter in a text string | Excel Worksheet Functions | |||
| Count Occurance of Text/Word in a Range | Excel Discussion (Misc queries) | |||
| Count Occurance | Excel Worksheet Functions | |||
| Count the occurance of a value x a value in another cell in excel | Excel Worksheet Functions | |||
| Excell: count occurance of letters in a column | Excel Worksheet Functions | |||
Threaded Mode
