Archive for INDIRECT function
How to use the INDIRECT function
The INDIRECT function returns the cell reference based on a text string and shows the content of that cell reference. […]
Prevent duplicate records [Data Validation]
Debra Dalgleish demonstrated last week how to block duplicate entries in excel table. I made a comment and I thought I would share […]
Drop down list changes cell formatting
You can apply different conditional formatting formulas and formatting to a cell range, using a drop down list. Here is […]
Use Conditional Formatting to do lookups in related tables
It can be really hard trying to follow a lookup in related tables. I will show you how to use […]
How to use a Table name in Data Validation Lists and Conditional Formatting formulas
David Hager gave this valuable comment about how to reference a table name in conditional formatting formulas: =INDIRECT("Table1[Start]") Watch this video to […]
Table of contents Initials from first and last names Initials from first, middle and last names Create middle name initials […]
How to use absolute and relative references
What is a reference in Excel? Excel has a A1 reference style. Columns are named letters A to XFD. Total […]
Invert a list using cell references
Question: How do I invert / reverse a list using cell references? My list is in D3:D7, see picture below. […]
