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


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

    Hi


    Could someone please tell me if it is possiable to do a find function to find the lowest value in a colum and then output that entire row. e.g a list of dates, I need to know what is the oldest date and what row that is for reference.