Find lowest number in groups then lowest overall.

HI

I have attached a revised version of your file with the values you were looking for highlighted in blue.

This uses a combination of the MIN function to determine the minimum value in each section, plus the Rank function to determine its position overall and then using nested IF to display the result.

I hope that this is what you are looking for, please let me know if it is not.

Regards

Jeff

Thanks,
How do you treat the cell if it's blank?
it should not rank if blank or if the any of the times are the same

HI

Depends which values you are referring to.

If you use rank then it will if ranking in ascending order treat zero as the first position. Identical values would be ranked equally e.g. from three values joint first and third.

You could get around the blank value by using an IF function to display a suitable high value that will automatically be ranked third, e.g

Please Login or Register  to view this content.

and then as the formula that was used tests for an identical value it will automatically display zero.

Regards

Jeff

Originally Posted by solnajeff

HI

Depends which values you are referring to.

If you use rank then it will if ranking in ascending order treat zero as the first position. Identical values would be ranked equally e.g. from three values joint first and third.

You could get around the blank value by using an IF function to display a suitable high value that will automatically be ranked third, e.g

Please Login or Register  to view this content.

and then as the formula that was used tests for an identical value it will automatically display zero.

Regards

Jeff

Did you mean...

Please Login or Register  to view this content.

neither work,

HI

Sorry with my settings Excel uses semi colons, please replace them all with commas for it to work.

Regards

Jeff

No Problem,

One more thing, how do you handle it when you have a tie?
if 2 times in the same group were the same? I can only have one best per group.