ANmar

When Excel tells you to go get some life

ANmar Excel User tips / Non-functions / Worksheet January 29, 2019 January 29, 2019

This is what happens when you spend too much time in Excel Go have a break and get some life

DayName

ANmar Date and Time / Standard functions / TEXT / Texts and Strings January 25, 2019 January 22, 2019

Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only that day name This is …

Shades of gray

image ANmar Graphics / Non-functions / Worksheet color / gray / shade January 25, 2019 January 25, 2019

We need this to be documented s8mewhere

So, here it is

Full article“Shades of gray”

Recover the unrecoverable

ANmar Excel User tips / Worksheet recover / restore / temp January 23, 2019 January 21, 2019

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 the limit of the application.

Fixed length ID

ANmar Formulas - combined functions / REPT / RIGHT / Texts and Strings REPT / RIGHT January 22, 2019 January 22, 2019

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 numbers to be converted into …

SimpleANBox

ANmar Basic Math / DATE / Date and Time / Formulas - combined functions / IF / IFERROR / Logical / Math and Trig / SUM / TODAY / WEEKDAY / Worksheet DATE / IF / IFERROR / SUM / TODAY / WEEKDAY January 21, 2019 January 21, 2019

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 with technology (since 1997) I …