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.
|