'How to build this QUERY getting the latest entry based on a time stamp?

So I am trying to get the latest entry based on a column containing the timestamp, but I'm not getting my head around getting that entry without necessarily selecting that column.

G Sheets Sample data

Appreciate your help very much!

arrayssortinggoogle-sheetsgoogle-sheets-formulavlookup


Solution 1:[1]

try:

=INDEX(IFNA(VLOOKUP(B5:B&C5:C&D5:D; 
 SORT({'From this sheet'!G2:G&'From this sheet'!H2:H&'From this sheet'!I2:I\'From this sheet'!Q2:Q}; 
 ROW('From this sheet'!Q2:Q); 0); 2; 0 )))

enter image description here

update:

=INDEX(IFNA(VLOOKUP(C5:C&D5:D; 
 FILTER({'From this sheet'!H2:H&'From this sheet'!I2:I\'From this sheet'!Q2:Q}; 
 'From this sheet'!R2:R="Finalizado"); 2; 0 )))

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions