comparing rows
 

Hi, I was wondering if theres a way of comparing one row of data
against another ie:
if data in a1:aa1 is the same as data in a2:aa2. I know how to do it
looping through the cells one at a time. I was just thinking if theres
a quicker way.
Regards Robert

comparing rows
 

Possibly the looping could be made quicker, but I think the basic approach is
to compare cell by cell. Obviously, a thorough knowledge of the data may
enable some shortcuts.

--
Regards,
Tom Ogilvy


" wrote:

Hi, I was wondering if theres a way of comparing one row of data
against another ie:
if data in a1:aa1 is the same as data in a2:aa2. I know how to do it
looping through the cells one at a time. I was just thinking if theres
a quicker way.
Regards Robert

comparing rows
 

Thankyou for you reply. Im using a looping routine which loops through
the cells which is fine. Just thouht there may have been different
ways, as basically what I do is if one row doesnt = the other row I can
keep it otherwise delte the row. Thanks for taking the time.
Regards Robert