Monday, July 30, 2012

yogi_Split A Master List Into Several Parts By Specified Group Of Letters Such As A-F G-M And N-Z

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #664   Jul 30, 2012     www.energyefficientbuild.com.


user PriestessMars said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/la7WxKGBM4Q)
Splitting a Master List into three separate lists based on letter of alphabet
I have a Master List, filled with 200 or so names.  Is there a way to separate that list into three smaller lists by last name, (for example, Sheet 1 would contain last names that beginning with the letters A-F, Sheet 2 G-M, and Sheet 3 N-Z) where the lists would be updated as the master list is updated, without doing it manually?
------------------------------------------------------------------------------------------
following is a solution to the problem


No comments:

Post a Comment