Hello guys
I am sitting in front of following problem:
=index(WFP!A1:Z100; match("Shipping duration";*WFP!$A:$A*;0);match(filter(
Products!I:I;Products!G:G=D5;0)
My point is that in the *WFP* sheet there are 12 rows with "Shipping
duration"
1) "Shipping duration" / 1.01.2014
2) "Shipping duration" / 1.02.2014
3) "Shipping duration" / 1.03.2014
4) "Shipping duration" / 1.04.2014
5) ect, ect.
and I need to get the row number of this "Shipping duration" row, with
the latest date.
Has anyone any idea what should I add to my *WFP!$A:$A* reference
Thanks for your help
Mingkai
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
