Posted to microsoft.public.excel.misc

caldog[_2_] caldog[_2_] is offline

external usenet poster

Posts: 8

Finding Next Occurrence

It is working now, except that it is finding all occurences of 301.
The two rows of "Data", $19,201.28, $547.98, and "Total" amount
$19,749.26.

What I am needing is for it to find all of the dollar amounts
associated with the word "Data" and the Code # "301". When it finds
the word "Total" that is when I need the formula to ignore the amount
in column L of my example.

Thanks again for the code.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
vlookup on first occurrence of X after Y?	jim	Excel Worksheet Functions	3	January 9th 08 02:24 AM
Max value for each day, and hour of that occurrence	Rich	Excel Discussion (Misc queries)	2	December 5th 07 09:45 PM
Finding the most/least/average occurrence(appear) number?	cinoV	Excel Discussion (Misc queries)	7	March 2nd 06 06:08 AM
find last occurrence	REMnLYN	Excel Worksheet Functions	9	March 29th 05 10:43 AM
Max number of Occurrence	Saadi	Excel Worksheet Functions	5	January 28th 05 03:06 AM

All times are GMT +1. The time now is 04:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us