Walking Columns
An easy way to scroll through set of data in a graphic way without graphs. A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.
Standard functions that comes with Excel, plain single functions
An easy way to scroll through set of data in a graphic way without graphs. A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.
This was an interesting request. Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions. So, sharing here on what is the formula …
I needed to have an offset of columns to be repeated every 12 months. This is part of a project, we needed to calculate the coefficient of sales prediction based …
This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.
This is the spreadsheet to prove this constant. When all roads lead to Kaprekar Just enter any 4 digits number in D3 and watch roads walk you 6174
An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using …