Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • CTRL+Y a mini macro Excel User tips
  • Cuts string of list of items Formulas - combined functions
  • Standard math to calculate Aspect Ratio Basic Math
  • Dynamic selection list ActiveX controls
  • VLookup Lookup and References
  • Edit directly in cell Excel User tips
  • Min Max vehicle Formulas - combined functions
  • 0% interest promotion Basic Math

Category: Non-functions

Compare2, a tool to compare two sheets using formulas

Posted on December 5, 2018 By ANmar
Compare2, a tool to compare two sheets using formulas

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 these two files are open, then sheet will be updated with comparison results, showing that every cell is checking for its equivalent addresses from both…

Read More “Compare2, a tool to compare two sheets using formulas” »

Conditional Formatting, Formulas - combined functions, IF, Logical, Standard functions

Edit directly in cell

Posted on December 5, 2018 By ANmar
Edit directly in cell

One of the settings that I always change when I first get a new Excel installation is …

Remove “Edit directly in cell”

Here is where you find that option

Read More “Edit directly in cell” »

Excel User tips, Non-functions

Skills Grid

Posted on October 26, 2018 By ANmar
Skills Grid

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

Read More “Skills Grid” »

Conditional Formatting, Data Validation, Formulas - combined functions, IF, IFERROR, Logical, Lookup and References, Names, Non-functions, OFFSET, Standard functions, VLOOKUP, Worksheet

Convert cell into textbox

Posted on March 28, 2018 By ANmar
Convert cell into textbox

Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on that particular single input (or more)

So, i learned a trick, it is formatting the entire sheet to certain color and give that cell special format to make it look like a textbox.

Read More “Convert cell into textbox” »

Excel User tips, Graphics, Non-functions, Worksheet

Highlight dates dynamically

Posted on March 14, 2018 By ANmar
Highlight dates dynamically

Conditional formatting is another powerful feature in Excel, especially when you combine it with functions

A simple function as in below if you set it up inside Conditional formatting, can do magic

Read More “Highlight dates dynamically” »

AND, Conditional Formatting, Non-functions, Standard functions, TODAY

Excel ad from early 90s

Posted on March 14, 2018 By ANmar
Excel ad from early 90s

Guess what I just found in my old archive !

Non-functions, Worksheet

Show developer tab

Posted on February 16, 2018 By ANmar
Show developer tab

Starting Excel 2007, users are not getting easy access to developer stuff.

Not sure why is that, but we can go around that, so quickly, if you need to start developing inside Excel (using VBA) first thing to do is to show the “Developer” tab that came in hidden by default

Just follow on these steps

Read More “Show developer tab” »

Excel User tips, Non-functions

Excel sessions – 2013 VS 2010

Posted on June 9, 2017 By ANmar
Excel sessions – 2013 VS 2010

Excel 2010 was great because you can easily open another Excel session while your current session is working.

This allowed us to run multiple tools at the same time, since those two sessions are separated and do not touch.

However, starting Excel  2013, the interface changed, making it harder to run new session or open Excel while we have another Excel session running some long process.

Read More “Excel sessions – 2013 VS 2010” »

Excel User tips, Non-functions

State Abbr with Index+Match+Validation

Posted on February 14, 2012 By ANmar No Comments on State Abbr with Index+Match+Validation
State Abbr with Index+Match+Validation

Small file that will show how to do INDEX + MATCH formulas to get the abbreviation of the state based on its name or the name of the state based on its abbreviation

Main formula to do that is:

=INDEX(Abbr_States,MATCH(B4,States,0),1)

Read More “State Abbr with Index+Match+Validation” »

Data Validation, Formulas - combined functions, INDEX, Lookup and References, MATCH, Standard functions

Multiple Dual-Validations

Posted on February 9, 2012 By ANmar No Comments on Multiple Dual-Validations
Multiple Dual-Validations

It is to demonstrate how to do multiple validations in the same sheet, or as we want to call it

Mutliple-dual-validations

that depend on each other.

Checking out sheet “Data”, you can tell that Validations on column B is for the heads (Main categories), and on column D is for the sub category of the main that used in column B in that row.

Creating something like this basically falls in three parts

Part1: is the Names you need to define, so after we create the table found “Data” sheet …..

We need to set two names, one for the left-top cell for that table (used as reference) and another name with formula:

Read More “Multiple Dual-Validations” »

COUNTA, Data Validation, Formulas - combined functions, Lookup and References, MATCH, Names, OFFSET, Standard functions

Multiple-Validations (connected to each other)

Posted on February 7, 2012 By ANmar No Comments on Multiple-Validations (connected to each other)
Multiple-Validations (connected to each other)

Here is the free file for a special request by a client
He wanted to have multiple cells having Data – Validation to same list but minus the selected one

In English, once you select one from cell1, cell2 will bring the same list but without the selected one, then when you select another item is selected in cell2, cell3 will bring what left from the list.

Does that make sense, check out the screenshots

Read More “Multiple-Validations (connected to each other)” »

Data Validation, Formulas - combined functions, IF, Logical, Standard functions

Posts pagination

Previous 1 2 3 4 Next

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Recover the unrecoverable Excel User tips
  • Count cells with condition – multiple conditions COUNTIFS
  • Hello world! Uncategorized
  • Unix DateTime Number Basic Math
  • CHOOSE – tree of decisions CHOOSE
  • Validation based on another Validation COUNTA
  • Sheet() and Sheets() Lookup and References
  • VALUE() of LEFT() Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme