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    Jan 27, 2013
user Testus said:(!category-topic/docs/spreadsheets/BgPI0d9qyQ8)
Sort unique from multiple sheets in one formula

This works for one sheet:


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