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

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 1 year 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 1 year ago

Topic Closed

This topic has been closed to new replies.

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers


Go check your email!