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 3 years ago by Enthusiast
  • Latest reply from moreeg
  • Topic Viewed 1109 times


Recommended: Clean Your PC the Easy Way with CleanMyPC

If you want to clean up your PC the easy way, CleanMyPC is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyPC for Free Today

Posted yesterday 
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 3 years ago
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 3 years ago

Topic Closed

This topic has been closed to new replies.