Author: ANmar

Blank (isempty) VS “” (null string)

Excel keeps converting all cells to “Date” (or Time)

When Excel functions are not enough

Excel Limits

Count Unique

Cell formats 0.0\% and 0.0%;(0.0%)

When Excel tells you to go get some life

DayName

Shades of gray

Recover the unrecoverable

Fixed length ID