Home > Mobile >  Sheets: Find first and last occurrence of a value in a range
Sheets: Find first and last occurrence of a value in a range

Time:11-06

I have been struggling with the Google Sheets query for several hours and maybe getting confused how to combine HLookup and VLookup (or any other function) in a way that can find the first and last occurrence of a value in a sheet based on the date header above it.

Here is an example sheet for reference which is very clear, but I will try explain verbally as well ... enter image description here

  • Related