With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, October 9, 2012
yogi_Setup A CrossTab For Sale Quantities To Different Entities By Year And Month
On the Summary sheet, I have filter formulas in columns B and C to sum the quantities from the Data sheet that meet two criteria.
The real spreadsheet is more complicated, and I would like to reduce the number of formulas to speed it up and make it more efficient. Can I replace the filter formulas with one arrayformula per column (or is there a better option)?