Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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
No comments:
Post a Comment