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
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