Return value AFTER column meets condition

Hello,

One of my columns, we'll call it A, is a list of independent values (just numbers.)

Let's say B is set to return "" or "Yes", depending on if a number of columns meet certain conditions.

Column C tells me which row column B finally returns Yes.

I want column D to return the max in column A after column B finally returns Yes. So, if column C returns 3, I want column D to display max of current A-row to A3. If C returns 4, I want column D to display max of current A-row to A4. can this be done?

thank you!

Maybe a worked example using real numbers as an attachment would help explain a little more fully.

Hmm . . .

I want to return the minimum of all cells that meet a certain condition.

The data (or numbers) in column A, under certain criteria in column B, meet either the conditions for "Yes" or the conditions for "No." I want to return the MIN of only of the "Yes."

...If the numbers in A meet the conditions for B to return "Yes" then I want C to find the MIN of only "Yes".

Is there a way? ... Gotta be a way ... gotta be. Thanks!