I have the following data in a Google Spreadsheet:
1 shiplu rice 2 sharmin rice 3 sharmin fast food 4 sharmin salad 5 rafiq burger 6 nazia noodles 7 rafiq salad 8 rafiq noodles 9 nazia rice 10 razib rice
The first column is in fact a timestamp, but I used integer to make it more readable. The other columns are username and food item.
I need to get the last food inputed by an user. The output should looke like this:
1 shiplu rice 4 sharmin salad 8 rafiq noodles 9 nazia rice 10 razib rice
I used the following query, but it does not give the desired output:
=QUERY(A1:C10;"select B, C group by B order by A")
How can I achieve this?
This is the spreadsheet in question.