• Std fxs
    • Basic Math
    • Date and Time
    • Engineering
    • Information
    • Logical
    • Lookup and References
    • Math and Trig
    • Texts and Strings
    • Formulas – combined functions
    • Array formulas
  • Custom fxs (UDF)
    • What is this UDF?
    • HyperlinkOf UDF
    • WorksheetsNo UDF
    • WorksheetName UDF
    • Num2AR UDF
  • Non-fxs
    • Names
    • Data Validation
    • Conditional Formatting
    • ActiveX controls
    • Graphics
    • Excel User tips
  • About
    • Contact
    • About XLf(x)s
    • King of Excel
    • Admin
  • Search
XLf(x)s = Excel Functions

XLf(x)s = Excel Functions

Excel functions and formulas
Skip to content
  • Std fxs
    • Basic Math
    • Date and Time
    • Engineering
    • Information
    • Logical
    • Lookup and References
    • Math and Trig
    • Texts and Strings
    • Formulas – combined functions
    • Array formulas
  • Custom fxs (UDF)
    • What is this UDF?
    • HyperlinkOf UDF
    • WorksheetsNo UDF
    • WorksheetName UDF
    • Num2AR UDF
  • Non-fxs
    • Names
    • Data Validation
    • Conditional Formatting
    • ActiveX controls
    • Graphics
    • Excel User tips
  • About
    • Contact
    • About XLf(x)s
    • King of Excel
    • Admin
  • Search
XLf(x)s = Excel Functions

XLf(x)s = Excel Functions

Excel functions and formulas

Count Unique

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 …

Full article"Count Unique"

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

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 …

Full article"Cell formats 0.0\% and 0.0%;(0.0%)"

When Excel tells you to go get some life

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

Full article"When Excel tells you to go get some life"

DayName

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 …

Full article"DayName"

Shades of gray

We need this to be documented s8mewhere

So, here it is

Full article“Shades of gray”

Recover the unrecoverable

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.

Full article"Recover the unrecoverable"

Posts navigation

1 2 3 … 12

Other websites

  • ANmar.Systems
  • BoldCodes
  • MyResume.cc
  • Folder8
  • Alwah.net – ألواح
  • ArabicNames.US
  • Excelication.com

Linkedin profile

ANmar Amdeen
Powered by Kahuna & WordPress.
©2018 XLf(x)s=Excel Functions | ANmar.Systems
Back to Top

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close