# Posts by Taji

• ## Return Min Value - If Statement

Hi

I am going to try explain this situation again as I think I didnt really do a good job last time.

What I need to do is to have 2 rows (A & B). Row "A" is going to have a list of dates and row "B" will either have "Yes" or "No" vaules.

What I need to do is to return the value with the oldest date but only if it has "No" in row "B"

Thanks

• ## If Statement & Min Value

Re: Return Min Value - If Statement

Hi Biz

That is just returning the lowest value without the arguement. So it is not validating it correctly.

• ## If Statement & Min Value

Re: Return Min Value - If Statement

Yes I could do that but I would liek it too be dynamic. So that I dont have to do anything because I am going to take this formula for a more advanced reason.

• ## If Statement & Min Value

Return Min Value - If Statement

Hi

I am going to try explain this situation again as I think I didnt really do a good job last time.

What I need to do is to have 2 rows (A & B). Row "A" is going to have a list of dates and row "B" will either have "Yes" or "No" vaules.

What I need to do is to return the value with the oldest date but only if it has "No" in row "B"

Thanks

• ## If Statement & Min Value

Hi

Could someone please give me advice on how to create a command that will search my row for the lowest value but only return it if another row is equal to "YES" e.g

What is the smallest number in row A. but that number in row A must be equal to "yes" in coloum B. Understand?

Thanks

• ## Find Lowest Value In Column

Re: Find Lowest Value In Column

Thanks for all your help! It is working now.

• ## Find Lowest Value In Column

Re: Find Lowest Value - Output Entire Row

hi

I dont understand know to use this function can you give an example, please

• ## Find Lowest Value In Column

Re: Find Lowest Value - Output Entire Row

ok,

lets say i want to find the lowest value in A1:A100 but once it has found it - it outputs the value B

i.e A5 is the lowest so but gives me B5(The cell right next to it.) understand?

• ## Find Lowest Value In Column

Re: Find Lowest Value - Output Entire Row