• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
WittySparks Logo White

WittySparks

Ignite Your Thoughts

  • Topics
  • Reviews
  • Services
  • Newsletter
WittySparks / Technology / Software / How to find repeated values in a sheet? – MS Excel 2007 Tips

How to find repeated values in a sheet? – MS Excel 2007 Tips

Updated: January 29, 2022 by Kartik Subramaniam • < 1 min read

Conditional Formatting MS Excel 2007

For those of you who wish to find repeated values in a sheet full of numbers, Using CTRL+f would yield the desired value one at a time and if the sheet is full of data then you are up against some task! To find values simultaneously there is another simple way in Excel 2007- Conditional Formatting.

Suppose you have the following set of numbers in a sheet and you need to find the number 10 in the entire array (the set of data provided)

Conditional Formatting MS Excel 2007
Conditional Formatting MS Excel 2007

Type Alt+h+l and this opens the box for conditional formatting which appears as below.

Conditional Formatting - MS Excel 2007
Conditional Formatting – MS Excel 2007

In the highlight cell rules, click the first option which says Highlight Cell Rules.

Go to the last option – Duplicate Values and click on it. You would find this box appear on your screen.

In the left field, there is a dropdown list that has two options, Duplicate and Unique. To find all the duplicate values in an array, select Duplicate.

Conditional Formatting Duplicate Values - MS Excel 2007
Conditional Formatting Duplicate Values – MS Excel 2007

In the right-hand side field, select any of the options in the dropdown list such as “Light Red Fill with dark red text“

Click OK and you would find that repeated values are highlighted in the sheet.

Conditional Formatting Result
Conditional Formatting Result

The next post shall try to throw some light on finding values in a range and using conditions to find values. Hope this post was of use.

Related Topics

  • QuillBot Review: Is this “The Ideal Writing Tool” You Are Looking For?
  • AppSumo Review? Contains a List of the Best AppSumo Deals!
  • Revolutionizing Artistry: The Mesmerizing Power of AI Portrait Generator
  • CleanShot X for MacBook: A Comprehensive Hands-On Review

Topic: Software

Profile picture for Kartik Subramaniam Article by

Kartik Subramaniam

A dreamer of sorts & a Creative writer, passionate about reading diverse stuff.

View all posts by Kartik Subramaniam

Primary Sidebar

Featured Productivity Software

Notion logo
Notion

Notion Workspace can help you stay organized and take your productivity to the next level. Use Skillshare coupon code WITTYSPARKSFREE to watch the Notion Masterclass by Ali Abdaal for FREE.

Take Free Notion Masterclass

The Best Digital Marketing Tool

Semrush logo
Semrush

Semrush helps grow your business on your terms and gets to the top with 55+ marketing tools in 1. Get a flat 40% discount on Guru plan or Try 14-day PRO Trial.

Try Semrush for FREE

Footer

Explore Topics

  • Technology
  • Business
  • Marketing
  • SEO
  • View All Topics

Sponsors

Partnered with FreePik to use the licensed images.

turn to dhgate for smartphone

Affiliate Link Disclosure

If you make a purchase from links, we will receive a small commission. See our Affiliate Disclosure.

Follow Us

  • Facebook
  • Twitter
  • Pinterest
  • LinkedIn
  • Instagram
  • YouTube
  • RSS
  • Mastodon

Copyright © 2023 WittySparks - All rights reserved.
Hosted on Rocket.net

  • About Us
  • Contact Us
  • Privacy Policy