Posted to microsoft.public.excel.worksheet.functions

LOU

external usenet poster

Posts: 40

Find the next occurance

I want to find each occurance of a certain value in a worksheet. The value
can occur once or several times. Each time the value occurs, I need to list
related data.

Hlookup works great to find the first occurance, but how do I get it to find
the next occurance and then the next, etc?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find nth occurance of data	yshridhar	Excel Worksheet Functions	4	February 16th 08 05:19 PM
help to find a string for 4th occurance	Eddy Stan	Excel Worksheet Functions	1	September 22nd 07 11:13 PM
Macro to find last occurance	hnyb1	Excel Discussion (Misc queries)	2	June 8th 07 04:40 PM
Find next occurance	Jambruins	Excel Discussion (Misc queries)	5	August 10th 06 04:48 PM
Find last occurance of text in range	farutherford	Excel Worksheet Functions	5	August 30th 05 02:00 AM

All times are GMT +1. The time now is 11:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us