New answers tagged

0 votes

Creating a formula on output sheet to extract from range of cells using Min/Max (Need to skip 24 rows) and output w/out 24 rows between each row

Sheet: Output, Cell: A3 =query({arrayformula(vlookup(ARRAYFORMULA({query(query({Data!D3:D,arrayformula(to_date(int(Data!G3:G)))},"select Col2, Max(Col1) group by Col2 order by Col2 desc label Max(...
user avatar
  • 4,768
0 votes

Creating a formula on output sheet to extract from range of cells using Min/Max (Need to skip 24 rows) and output w/out 24 rows between each row

I edited your file. You can get what you want with a very complex, draggable formula, which I hope you can figure out for yourself. If you need any explanations, feel free to ask.
user avatar
  • 1,276

Top 50 recent answers are included