Compare Rows - any unique into new sheet / delete duplicates

buffyslay

New Member
Joined
Oct 28, 2004
Messages
31
Compare Rows - any unique into new sheet / delete duplicates

OK, I have a worksheet comparing sets of data in one sheet. Many
columns. around 2500 rows


1: I need to compare rows and copy any unique values into a different
sheet.
then i need to split these out based on the value in col A (there
will only be 2 values)


2. back to original doc, this now needs all the duplicates removing


simple?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

1: I need to compare rows and copy any unique values into a different
sheet.

comparing which cells in which columns. e.g. Col A only, Col A and Col B, etc...

Perhaps if you gave a small sample of your data and the expected results.
 

buffyslay

New Member
Joined
Oct 28, 2004
Messages
31
although col A will have different data.... thats a pain

i am comparing this month headcount against last months, number of cols / rows will differ, so need to compare cols B to usedrange
 

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows

ADVERTISEMENT

Hello,

I know you need a unique row, but how do you determine a unique row, if row 1 is

A B C D E

and row 2 is

F G H I E

is this unique or not.

Can you give a sample of data and the expected results?
 

buffyslay

New Member
Joined
Oct 28, 2004
Messages
31
your example above is correct

Date 1 : a b c d
Date 2 : a b c d - match

Date 1 : a b c d
Date 2 : a b c e - flag
 

scu77

New Member
Joined
Sep 14, 2005
Messages
22
hi..

try like this

1. union cells

ex> a1 & "," & b1 & "," c1
a2 & "," & b2 & "," c2


2. Advanced filter / unique item


3, text to columns / comma
 

buffyslay

New Member
Joined
Oct 28, 2004
Messages
31
thanks - but i want (to be awkward) to do this in VBA

I know that i will have at least 4000 records and want to automate is....

maybe i need a multi array?

so far i have

Dim R, C
Dim Arr()
R = ActiveSheet.UsedRange.Rows.Count - 1
C = ActiveSheet.UsedRange.Columns.Count - 1
ReDim Arr(R, C)


now i have to populate it???
 

Forum statistics

Threads
1,136,418
Messages
5,675,713
Members
419,584
Latest member
mrh8rr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top