英文:
Query: Data&Time Max group B
问题
09/02/2023, 13:30:01 MARIO
09/02/2023, 14:04:57 LUCA
英文:
I have the following data and I need to derive the max date (date and time) A for group B in google sheets.
A B
09/02/2023, 11:37:44 MARIO
09/02/2023, 11:42:41 MARIO
09/02/2023, 11:48:03 LUCA
09/02/2023, 13:03:06 LUCA
09/02/2023, 13:08:24 MARIO
09/02/2023, 13:15:57 LUCA
09/02/2023, 13:20:25 MARIO
09/02/2023, 13:23:38 MARIO
09/02/2023, 13:30:01 MARIO
09/02/2023, 13:33:36 LUCA
09/02/2023, 13:38:41 LUCA
09/02/2023, 13:41:38 LUCA
09/02/2023, 13:58:50 LUCA
09/02/2023, 14:04:57 LUCA
OUTPUT
09/02/2023, 13:30:01 MARIO
09/02/2023, 14:04:57 LUCA
=Query(Dati!A1:M,"Select B, Max(A) where B <> '' group by B label max(A) ''",0)
No MAX
答案1
得分: 1
尝试在运行查询之前移除逗号：
=ArrayFormula(Query({SUBSTITUTE(A1:A,"","),B1:B},"Select Col2, Max(Col1) where Col2 <> '' group by Col2 label max(Col1) ''",0))
英文:
Try to remove the commas before running the QUERY:
=ArrayFormula(Query({SUBSTITUTE(A1:A,",",),B1:B},"Select Col2, Max(Col1) where Col2 <> '' group by Col2 label max(Col1) ''",0))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论