ANmar – XLf(x)s = Excel Functions

Count Unique

ANmar COUNTIF / Formulas - combined functions / IF / Standard functions / Statistical / Uncategorized CountIF / IF August 9, 2019 August 9, 2019

A question by a colleague on how to count number of unique items in a column made me realize, I don’t have that here.

So here it is …

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

ANmar Format Cells / Non-functions / Worksheet cell / CTRL+1 / format April 7, 2019 April 9, 2019

We needed a way to force Excel to show the % next to a number without dividing it by 100 You know, when you format a cell in Excel, to …

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

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.