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.
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 coefficient of sales prediction based …
Return 12 values in one number
A technic I loved using, return list of items (up to 12 items now) in ONE number. Let us say you have list of 12 items, and you want a …
Cells with additional spaces
Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = “No”, LEN(F2) >2, “Space at end”, “”)
Always get 1st name (or last)
Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.
VALUE() of LEFT()
I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes not, others VALUE() worked, but …
Schedule column
Create list of dates excluding weekends and holidays.Basically create list of workdays in a certain year, you may fill in to get more. List of holidays is defined in another …