Logical – 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 …

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 …

Scorring, saving multiple outputs in 1 number

ANmar Basic Math / Conditional Formatting / Formulas - combined functions / Logical / Non-functions / Standard functions December 10, 2018 January 21, 2019

I have seen this practice before several locations Returning multiple outputs in 1 single number. for example

Compare2, a tool to compare two sheets using formulas

ANmar Conditional Formatting / Formulas - combined functions / IF / Logical / Standard functions December 5, 2018 December 6, 2018

Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in file1 and file2. Make sure …

BMI Calculator

ANmar Basic Math / IF BMI / Calculator / Convert December 5, 2018 December 5, 2018

A simple calculator, how come we do not have one like this?

Skills Grid

ANmar Conditional Formatting / Data Validation / Formulas - combined functions / IF / IFERROR / Logical / Lookup and References / Names / Non-functions / OFFSET / Standard functions / VLOOKUP / Worksheet October 26, 2018 December 5, 2018

A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the level of expertise in each