How do I identify duplicate numbers in Excel?

[Patrick]

I have an excel sheet with 4 columns and over 700 rows
Columns:
1 ID number
2 First name
3 Last name
4 Location

My concern is the ID number. Is there any function, without scrolling
through the entire list, that I can use to identify Duplicate numbers?

[Bernard Liengme]

Hi Patrick:
Visit Chip's site Duplicates
http://www.cpearson.com/excel/duplic...tingDuplicates
where there is tons of stuff on duplicates
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Patrick" <[email protected]> wrote in message
news:[email protected]...
>I have an excel sheet with 4 columns and over 700 rows
> Columns:
> 1 ID number
> 2 First name
> 3 Last name
> 4 Location
>
> My concern is the ID number. Is there any function, without scrolling
> through the entire list, that I can use to identify Duplicate numbers?