View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
caldog[_2_] caldog[_2_] is offline
external usenet poster
 
Posts: 8
Default 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.