Tally serial number for excel

**kaiserkev** · 06-26-2009, 10:11 PM

Hi,

Thanks in advance for your help.

I have a excel file indicate those detail of our deploying PC list. i need some guide on how to check the serial number that is duplicate or not in the stock list.

i have 3 excel file, 1. Main list 2. Stock for PC serial number and 3. LCD serial number

**DonkeyOte** · 06-27-2009, 02:59 AM

Your example is not all that clear, perhaps you're saying you want to use Conditional Formatting against the values in A to highlight any serial numbers that appear more than once (once they have been collated from the various source files), if so then:

-- highlight A2:A100 (change according to likely quantity of data) being sure to select A2 first
-- Format -> Conditional Formatting
-- use a FormulaIs approach
-- set Formula to be: =COUNTIF($A:$A,$A2)>1
-- set Format to be applied to duplicates accordingly

Now if a number should appear more than once in your A2:A100 range all instances of said number will be formatted per your set format such that you can easily identify them.