View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Edwin Edwin is offline
external usenet poster
 
Posts: 21
Default Finding Duplicate Rows (Macro)

Hi,

I have a table with several rows and columns of information. I will
continue to add new information new rows and I want to make sure that I never
have duplicated a row.

So here is a simple example:

A B C
1 i 1 k

2 r 3 n

3 a 2 f

4 a 1 f


I want to be able to add another row of information and if the array in that
row from columns a to c matches an array I already have I want to be notified
and it would also be nice to know which array I am duplicating.

I would like to accomplish the task above, but using the VBA tool (macros).
Ideally I would get the Item Number (located in the first column) of the
array Im duplicating in a message box.

Any help would be greatly appreciated!

Regards,

--
Edwin