Unique Entries in Excel via a Conditional Format

Filtering to the rescue

Excel’s Conditional Formatting feature has a built-in unique option. Its unique option only identifies entries that are not repeated. This is different to the Advanced Filter Unique option which lists each unique item from a range once. To filter by entries only appearing once you can use Conditional Formatting with filtering. No formulas required.

Free Excel Webinar Recording – Format As Table Features

Feedback score 93%

In February 2019 I demonstrated how to use the Format as Table feature in Excel, including some advanced techniques.

Webinar Materials

Many of Excel’s features and functions work seamlessly with formatted tables. They can help you improve the structure and reliability of your spreadsheet files.

Formatted tables can allow you to create powerful reports like those in a relational databases.

Topics covered

  • advantages and limitations of formatted tables
  • keyboard shortcuts
  • using formatted tables with formulas
  • solutions to some of the limitations of formatted tables
  • using range names with formatted tables
  • using formatted tables with data validations
  • creating a running total
  • using PivotTables
  • Relationships (Data tab)

As always there will are a few more tips and tricks shared in the session.

Free Excel Webinar Recording – Budget Challenge

Feedback score 93%

In January 2019 I presented a webinar that examined a solution to a 4 dimension budget challenge. Download the materials using the button below and watch the video.

Webinar Materials

NOTE: This is not a beginner’s session.

This webinar is based on a budget scenario which you need to read before the session starts. It is only 3 pages long and included in the materials.

Topics covered include

  • using INDEX-MATCH (better alternative to VLOOKUP)
  • 3-D formulas and techniques to make using them easy
  • using a reporting template
  • validations
  • extracting sheet names
  • automating reports

As always there will are a few more tips and tricks shared in the session.

I have spent my days stringing and unstringing my instrument, while the songs I came to sing remain unsung.

Rabindranath Tagore (1864-1941)

 

Make a Dent

Do you use Indenting in reports? Example below.

If you do, you make like this keyboard shortcut.

To increase Indenting press Alt H 6 pressed in sequence, not held down.

To decrease Indenting press Alt H 5 (is that an Outdent?)

 

Related Posts

 

Plan for the future because that’s where you are going to spend the rest of your life.

Mark Twain (1835-1910)

Free Excel Webinar Recording – Excel Yourself 2018

Feedback score 89%

In December 2018 I reviewed four of my articles from the INTHEBLACK magazine from 2018. Download the materials using the button below and watch the video.

Webinar Materials

Includes extra content not included in the magazine.

This year’s smorgasbord webinar includes

  • how to handle validations
  • dynamically highlighting the current row in a table (uses a macro)
  • centralising logic – how and why to do it – alternatives to the IF function
  • creating a slope chart (includes a macro to speed up the process)

As always there will be a few more tips and tricks shared in the session.

Open Filter the Drop Down

If you have filters turned on and you are in the heading row of the table you can press Alt + down arrow to open the filter drop down.

You can then use the arrow keys to move up and down.

Related Posts