Mail merge record number

I have created a spreadsheet to enter and track data. I'm using sheet1 to enter various data. In sheet2 I'm using a FILTER function to create a list based on values in column L in sheet1. The data in...

excel

Formulas and Functions

Patrick2788

Sep 26, 2023

Ahmed_Ezzedin

You could use SEQUENCE and do some stacking:

=LET(
    filtered, FILTER(B2:C8, C2:C8 = "a"),
    r, ROWS(filtered),
    auto_num, SEQUENCE(r),
    HSTACK(auto_num, filtered)
)

Forum Discussion

Mail merge record number

Resources