Forum Discussion
IF AND Query
Hi, Sorry if this is basic, but I'm still learning. This works - MIN(IF(Data!G:G=Answer!A2,(TIMEVALUE(Data!M:M)))) GG and A2 are names This works - MIN(IF(Data!L:L=Answer!H1,(TIMEVALUE(Data!M:M...
Variants are
=MIN( FILTER( TIMEVALUE(Data!M:M), (Data!L:L=Answer!H1)*(Data!G:G=Answer!A2) ) )and
=AGGREGATE(15,6, TIMEVALUE(Data!M:M)/(Data!L:L=Answer!H1)/(Data!G:G=Answer!A2),1)- Thanks
