Microsoft Excel Woes

ilovenerds

Hi!

I'm not quite as proficient at excel as I should be and would greatly appreciate some help. My aim is to find the minimum value in an imported column of figures. Once this data is retrieved I must then transfer the corresponding time this value was taken at(which is in the adjacent cell).

I have implemented two codes seperately and both seem to work until they are combined. This one produces the cell address of the minimum value:
=CELL("address",OFFSET(G2,MATCH(MIN(G2:G7),G2:G7,0)-1,0))
Returns:$G$4

This gives the time featured in the adjacent cell:
=IF(G6=A3,INDEX(F6:G6,1,1),)
Returns: dd/mm/yyyy

I need help formatting the cell address as when I attempt to revert the format to the standard "A2" rather than "$A$2", it returns just G. This signals a loss of information to me and I'm not sure why this occurs.

Can anyone suggest an alternative code or else help me fix the one I've created please? Apologies for the horrendous explanation of my predicament.:o

Mr November

Not sure if I follow exactly what you're looking for but something like this will return the date value based on the index match of the min value in column range for G

=INDEX($F$2:$F$7,MATCH(MIN(G2:G7),$G$2:$G$7,FALSE),1)

ilovenerds

Thank you. That worked very well. My apologies for the overly complicated description of what I was trying to do.:)

Mr November

No worries. Gald it seemed to work for you