Sunday, January 27, 2013

yogi_Extract Unique Values From Column A Of Sheet1 Sheet2 Sheet3 And Sort In Ascending Order


                                          Google Spreadsheet  Post  #989

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 27, 2013
user Testus said:(http://productforums.google.com/forum/?zx=rq2ugebf7h4a#!category-topic/docs/spreadsheets/BgPI0d9qyQ8)
Sort unique from multiple sheets in one formula

This works for one sheet:

=sort(unique(Sheet1!A2:A))

I need to combine data from (Sheet1!A1:A),  (Sheet2!A1:A) and (Sheet3!A1:A)  etc.. and make ONE list that sorts and removes duplicates.

Anyone know how to do this?
--------------------------------------------------------------------------------------------------------
following is a solution to the problem