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 ...
Hi! This can probably be generated with a dynamic-array formula such as FILTER, UNIQUE, SORT, or a combination of them. Please add a small example showing the source rows and the exact expected output, with private data replaced. That will make it possible to give you one formula instead of a manual process.