Forum Discussion
Solved
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...
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) )
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)
)
- Thank you very very much!
- You're welcome!
