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 ...
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")