Forum Discussion

BenjonBarachina's avatar
BenjonBarachina
Copper Contributor
Jul 09, 2026

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 ...
excel
IlirU's avatar
IlirU
Iron Contributor
Jul 10, 2026

Hi BenjonBarachina​,

You can try the following formula in Sheet2.

=LET(
     name, Sheet1!A2:A16,
       rx, REGEXEXTRACT(name, "."),
           FILTER(name, (rx >= "A") * (rx <= "D"), "No names found")
)

Use the same formula for the other Sheets but change only the letters. So instead of the letter A in the formula, put the letter E and instead of the letter D in the formula, put the letter J. Do the same for the other Sheets.

Change the range in the formula according to the real range you have in your data.

Hope this helps.

IlirU