I discussed the Google Docs MMULT function and its usage in my previous article now in this one I will be discussing a proper usage of that. If you have been using your GDocs spreadsheets for a while (which I assume you should   ) then you must have encountered situations where you need a FILTER [...]

Google Spreadsheet provides many formulas to make our life easy. One such formula is matrix multiply or MMULT. This formula provides great possibilities to otherwise lengthy drag and drop method of implementation. To start with I assume that you have a prior knowledge of matrices and matrix multiplication. If not try going through some brief [...]

While writing formulas in Google spreadsheets, doing drag and drop of formulas, ever wondered how to get rid or cleanup the cells which have a value as 0 or have errors ? There is a formula provided in Google spreadsheets ” IFERROR“. Basically this formula if encounters an error will replace the cell contents with [...]

Many of you have faced a situation where you do not want to create a new form with associated with a new spreadsheet, just because you want to reset the counters. As you might be aware by now that its not possible to delete existing responses, hence the only means left is to reset the [...]