Duplication warning

[pauluk]

Does anyone know how to creat a macro that runs in the background an
preforms the following:

If a enter information into a spreadsheet, then keep updating thi
spreadsheet with information there is away if i enter information int
a row and it is exactley the same as a perious row a error box pops u
adn says this is a dupication?

Regards
Pau

 

[Frank Kabel]

Hi
though this will not create a popup it will highlight your cell. Try
the following:
- Select your entire column (lets say col A, starting in row 1)
- goto 'Format - Conditional Format' and enter the following formula:
=COUNTIF($A:$A,A1)>1
choose a format to highlight a duplicate entry

For more information you may have a look at
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
http://www.cpearson.com/excel/NoDupEntry.htm

 

[Tom Ogilvy]

Possibly using data=> validation. If you are checking duplication for a
set of multiple columns, this might be less practical.

the alternative would be to use the change event for the worksheet.

See Chip Pearson's page on events
http://www.cpearon.com/excel/events.htm

 

[Tom Ogilvy]

You can also look at Chip Pearson's page on dealing with duplicates and
uniques for some other ideas:

http://www.cpearson.com/excel/duplicat.htm