Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning value next to the nth occurrence of a particular number.
Hi,
I have 2 columns. Column A has numbers, some of which are repeated numerous times. Column B has dates. How do I look up the nth occurrence of a particular number in column A and return the corresponding date? Any help greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Need help Returning the cell addy/index of the first non-zero number | Excel Worksheet Functions | |||
Max number of Occurrence | Excel Worksheet Functions |