New answers tagged


Put this formula in row 2 of an empty column: =arrayformula( iferror( vlookup( A2:A, unique(A2:B), column(A2:B) - column(A2) + 1, false ) ) ) The formula will grab the first value in column B in each range of column A where a new value appears for the first time. OUTPUT

Top 50 recent answers are included