MINIFS with OFFSET

[ollyhughes1982]

Hi all,

I'm having trouble combining MINIFS with an OFFSET. What I want to do is find the minimum value (if it isn't 0 or a blank) in column 'I' ('Distance from Home parkrun (K)') of the 'Miscellaneous Data - AP' worksheet - I can do this fine with the following formula:

=MINIFS('Miscellaneous Data - AP'!I3:I10002,'Miscellaneous Data - AP'!I3:I10002,"<>",'Miscellaneous Data - AP'!I3:I10002,">0")

However, I then want to return the value of the corresponding cell in column G ('Latitude, Longitude (Decimal Degrees'). Please see images of the formula I came up with, which doesn't work.

Thanks!

 

[ollyhughes1982]

Sorry for not being able to reply.. I will go through it and reply at the earliest

No problem, that's great. Thanks