generate list

BenjonBarachina wrote:

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.

there are a number of possible approaches to do this. as referenced by kidd_Ip you could use the FILTER function or use Power Query or you could even use pivot tables (and there are probably more options).  IMHO the FILTER function would be the easiest.  A formula on sheets 2-x would be something like:

=FILTER(sheet1!A1:.ZZ9999,  (UPPER(LEFT(sheet1!A1:.ZZ9999,1))>="A")*(UPPER(LEFT(sheet1!A1:.ZZ9999,1))<="D"), "none found")

Take this, support.microsoft.com/en-us/excel/functions/filter-function, support.microsoft.com/en-us/excel/about-power-query-in-excel