Google sheets select field by maximum timestamp & specific cell value-CodePudding

Home > Blockchain > Google sheets select field by maximum timestamp & specific cell value

Google sheets select field by maximum timestamp & specific cell value

Time：03-09

Here is an example google sheet for reference:

or:

=INDEX(IFNA(VLOOKUP(A2:A15, SORT({TokenTransfers!D2:D, TokenTransfers!C2:C}, TokenTransfers!A2:A, 0), 2, 0), B2:B15))