Standard functions – 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 …

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 …

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 August 9, 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 …

Looplist – Repeating months using formulas

ANmar Basic Math / Date and Time / Formulas - combined functions / MATCH / MONTH / OFFSET / ROW / YEAR December 11, 2018 December 10, 2018

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 through all months, then jumps …