XLf(x)s

Working a lot with Excel means seeing lots of errors and bugs inside Excel Some of those are not likely bugs, but more like reaching...

I needed few months back to make a fixed-length ID iut if none-fixed-length numbers. SO I used the function REPT with RIGHT to force all...

This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time...

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...

I have seen this practice before several locations Returning multiple outputs in 1 single number. for example...

Expenses calendar, to show when in a month you need to pay what bill An easy formula-only smart sheet to allow you get hold on...

Fully customized Yearly Calendar to show certain dates with certain format using conditional formatting, like mark 8th business day each month with certain color, 1st...