Looplist – Repeating months using formulas
Using formulas to repeat list, I call it LoopList Used to list Months for several years, in away that with 1 formula, it will loop through all months, then jumps …
Skills Grid
A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the level of expertise in each
OFFSET+MATCH
One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will allow you to do something …
Why I ran from =INDIRECT() function
I think if there is a single function that would be a huge threat to VBA and macros from user perspective, it would be INDIRECT() Yes, it wasn’t long enough …
Fx to cut long column into two columns
Convert one long column into two This set of formulas will get the items after row 45 (for example) from column A into the column B starting from B1 to …
iframe in Excel (XLiFrame)
This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is basically the same project as …