All articles with 'spreadcheats' Tag
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
![Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]](https://chandoo.org/wp/wp-content/uploads/2008/11/duplicate-items-excel-formula-find.gif)
Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they have provided features like clippy which are intrusive to say the least. So […]
Continue »Relative vs. Absolute References in Formulas [spreadcheats]
![Relative vs. Absolute References in Formulas [spreadcheats]](https://chandoo.org/wp/wp-content/uploads/2008/11/excel-relative-formula-references.gif)
This is the first installment of the spreadcheats series. I have used excel an year and half before I learned about the relative and absolute references. It was such a joyous feeling to find out that you can actually write one (or just a few) formulas and use the power of auto-fill to do the […]
Continue »Introducing Spreadcheats – Become Supergood with Excel in 30 days
![Introducing Spreadcheats – Become Supergood with Excel in 30 days](https://chandoo.org/wp/wp-content/uploads/2008/10/spreadcheats-excel-spreadsheet-productivity-tips.gif)
Starting next week, PHD is going to feature a 30 post series on spreadcheats. The purpose of these posts is to make day to day spreadsheeting a breeze. Each post will be less than 200 words in size and aspires to make your day at office a little bit more productive. I have already identified […]
Continue »