Middle name + 1st name
Get the initial (middle name) from a triple name in a cell.C4 The cell contains the triple name separated with spaces.=LEFT(C4,1) & "." & MID(C4,...
Jan8 date format
Format a date in shortest format possible indicating how many days have passed (Past date) If date1-date2 < 8 Sat, Fri, …If date1-date2 < 350...
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,...
Get 3rd Wednesday of month
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...
Repeated Offset
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...
Sorting with functions only
This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly....
6174 Kaprekar’s constant
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...