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)
Type Alt+h+l and this opens the box for conditional formatting which appears as below.
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.
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.
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.
Article by