Google SpreadSheet Query: How to find specific data

Question

data I have some data A1:G5 and i want to find latest fee from specific transactions (in WHERE -> FROM, Currency )

I have timestamp:

=QUERY(A1:G5, "SELECT MAX(A) WHERE F = 'Aaaa' AND C = 'PLN' ")

1) I dont want label.
2) How to get fee?

Answer:

Last Fee: 0.1

Timestamp: 13/02/2018 13:01:21

pnuts · Accepted Answer · 2018-02-25 18:58:37Z

2

Please try (it avoids MAX):

=query(A1:G5,"select E, A where F = 'Aaaa' and C = 'PLN' order by A desc limit 1",0)

answered Feb 25, 2018 at 18:58

59.7k11 gold badges92 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ed Nelson · Accepted Answer · 2018-02-25 21:02:24Z

Change your query to this to remove the label:

=QUERY(A1:G5,"SELECT MAX(A) WHERE F = 'Aaaa' AND C = 'PLN' LABEL MAX(A) ''")

To get the Fee, assuming the above query is in B11, enter this in A11:

 =VLOOKUP(B11,A1:G5,5,FALSE)