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

WittySparks

Ignite Your Thoughts

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

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

Software December 12, 2008 by Kartik Subramaniam

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

  • FlexClip Review: Is it the right tool for Video Creators?
  • Hubstaff Review: Is it the best time tracking tool?
  • Website Analytics: Almost Everything You Need To Know
Previous Post: « 60 NEW Excellent CSS Directories for Creative Inspiration!
Next Post: Google Puraskar for Gram Panchayats, INDIA »
Profile picture for Kartik Subramaniam

About Kartik Subramaniam

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

View all posts by Kartik Subramaniam

Primary Sidebar

Search

Exclusive Coupons

  • Moqups coupon code: WITTYSPARKS for 20% or PARTNERS50 for 50% discount.
  • WPForms coupon code: WITTYSPARKS for 50% off.
  • Serpstat coupon code: wittysparks_discount for 30% off.
  • SEO Buddy coupon code: WITTYSPARKS for 25% off.
  • Morningscore coupon code: wittysparks for 30% off for 3 months.
  • FlexClip coupon code: WITTYSPARKS for 30% off.
  • Uplead coupon code: “witty” for 30-day free trial.
  • FastestVPN coupon codes: WITTYSPARKS15 or WITTYSPARKS10 or Get up to 93% OFF.
  • Outranking.io coupon code: WITTYSPARKS50 for 50% off.

For more such offers visit our exclusive offers for SEO, Bloggers, Marketers and for Business owners.

Featured Productivity Software

Notion logo
Notion

Whether you’re a solo entrepreneur or a large team, Notion Workspace can help you stay organized and get more done. Get started today and take your productivity to the next level.

Try Notion for FREE

Footer

Affiliate Disclosure

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

Sponsors

Partnered with FreePik to use the licensed images.

turn to dhgate for smartphone

Follow Us

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

Copyright © 2023 · Hosting sponsored by Rocket.net (Affiliate link)

  • About Us
  • Contact Us
  • Privacy Policy
  • LinkedIn
  • Twitter
  • Like
  • Pinterest