SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

A quick trick for hiding duplicate Excel values

(2 posts)
  • Started 2 years ago by Enthusiast
  • Latest reply from moreeg
  • Topic Viewed 1109 times

Enthusiast
Enthusiast
Posts: 566

Check out this trick for hiding data that you may not want to see on your spreadsheet. A quick trick for hiding duplicate Excel values

Posted 2 years ago
Top
 
moreeg
moreeg
Posts: 842

Hi Enthusiast

We had a similar question a couple of weeks ago.

But, in my opinion, the best solution for this type of data presentation is pivot tables that will do exactly the same thing with more functionality e.g. totals and subtotals and with about the same effort as setting up a conditional format. Also, with the pivot table your original data is preserved as is so you always can refer back to it.

Posted 2 years ago
Top
 



Topic Closed

This topic has been closed to new replies.