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.
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.
Re: Find Lowest Value - Output Entire Row
try the INDEX & MATCH function
Re: Find Lowest Value - Output Entire Row
I think you would need to use VBA?
Re: Find Lowest Value - Output Entire Row
OK thanks for your help!
is there anyway that i could just return one cell - instead of the entire row.
Re: Find Lowest Value - Output Entire Row
Try this formula. It will give you the minimum value, even if the value is repeated in the range.
=SUMIF(A1:A100,"="&MIN(A1:A100))/COUNTIF(A1:A100,"="&MIN(A1:A100))
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?
Re: Find Lowest Value - Output Entire Row
Yes, I understand. See pangolin's suggestion.
Re: Find Lowest Value - Output Entire Row
hi
I dont understand know to use this function can you give an example, please
Re: Find Lowest Value - Output Entire Row
Hi,
try,
=index(b1:b100,match(min(a1:a100),a1:a100,0))
HTH
Re: Find Lowest Value In Column
Thanks for all your help! It is working now.
Don’t have an account yet? Register yourself now and be a part of our community!