Saturday, July 30, 2011

yogi_Separate Entries In A Document Into Different Sheets Based On Entry In A Specified Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

Macgriff said:
How do I sort a large document into different sheets based on a column? Ex. Sheet sorting based on city
I currently have a huge document with 8 colums. I want to sort column D (City) into different sheets. Is this possible?
I created a separate sheet named after each unique entry in column D data of Sheet1 and then I used the Filter function to extract all records matching the value in column D of Sheet1 with the entry in cell A1