| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find nth occurance of data
How to find out the nth occurance of the data in a table?
A B C 1 a 10 2 b 5 3 a 15 4 c 20 5 b 30 6 a 40 There are three'a' s in the table. I want to list out the value in the C-column for the third occurance of 'a' = 40. with regards sreedhar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help to find a string for 4th occurance | Excel Worksheet Functions | |||
| Macro to find last occurance | Excel Discussion (Misc queries) | |||
| Find the 1st occurance of a number in a cell | Excel Worksheet Functions | |||
| Find next occurance | Excel Discussion (Misc queries) | |||
| Find last occurance of text in range | Excel Worksheet Functions | |||
Threaded Mode
