Forum Discussion
generate list
Good day! I have a file that has list of all names on one sheet. is there a way to generate on a different sheet list of names based on the first letter of the names? like in sheet1 would be all the ...
is there a way to generate on a different sheet list of names based on the first letter of the names?
Try in 2nd sheet:
=LET(_names,Sheet1!A1:.A9999,FILTER(_names,ISNUMBER(MATCH(LEFT(_names);{"a";"b";"c"},0)),"No names"))modify matrix of first letters {"a";"b";"c"} in next sheets.
Bye.