Hi All,

I am asking too many questions but so does a child who learns
something new :-)

I have 5 columns of data. Each columns has different number of data
starting row 2. Row 1 has the column heading.

Column 1 has 34 data (which may vary)
Column 1 has 64 data (which may vary)
Column 1 has 13 data (which may vary)
Column 1 has 11 data (which may vary)
Column 1 has 37 data (which may vary)

In each column, some of the data is duplicate.

I need to generate a list with all the duplicate entries removed.

Assuming each of the 5 columns above has 10 original data only, then
my output should be 5 columns of data with 10 entries each.

Thanks in advance,
Anshuman

Each column is separate and distinct from the other columns--duplicates between
the columns don't matter?

If that's true, you can use data|filter|advanced filter 5 times and copy the
visible cells to a new worksheet.

Debra Dalgleish explains it in more details:
http://www.contextures.com/xladvfilter01.html#FilterUR

anshu wrote:

Hi All,

I am asking too many questions but so does a child who learns
something new :-)

I have 5 columns of data. Each columns has different number of data
starting row 2. Row 1 has the column heading.

Column 1 has 34 data (which may vary)
Column 1 has 64 data (which may vary)
Column 1 has 13 data (which may vary)
Column 1 has 11 data (which may vary)
Column 1 has 37 data (which may vary)

In each column, some of the data is duplicate.

I need to generate a list with all the duplicate entries removed.

Assuming each of the 5 columns above has 10 original data only, then
my output should be 5 columns of data with 10 entries each.

Thanks in advance,
Anshuman

--

Dave Peterson

Not able to figure it out...

I need to get past it using a macro as this step is in between a long
procedure...

So, somewhere bewteen the procedure, I will have a list stacked up
with 5 columns and unequal number of data in each column with some
repeat occurences ( no repeat between columns..all repeats are within
column)...

I need to write a macro so that the duplicates get deleted and I am
just left with 5 columns of unique data. Then I would count number of
data items in each column and name them differently...These names will
be used by my program later on to call this list...

Need Help

Thanks,
Anshuman

On Jul 16, 10:40 pm, Dave Peterson wrote:
Each column is separate and distinct from the other columns--duplicates between
the columns don't matter?

If that's true, you can use data|filter|advanced filter 5 times and copy the
visible cells to a new worksheet.

Debra Dalgleish explains it in more details:http://www.contextures.com/xladvfilter01.html#FilterUR



anshu wrote:

Hi All,

I am asking too many questions but so does a child who learns
something new :-)

I have 5 columns of data. Each columns has different number of data
starting row 2. Row 1 has the column heading.

Column 1 has 34 data (which may vary)
Column 1 has 64 data (which may vary)
Column 1 has 13 data (which may vary)
Column 1 has 11 data (which may vary)
Column 1 has 37 data (which may vary)

In each column, some of the data is duplicate.

I need to generate a list with all the duplicate entries removed.

Assuming each of the 5 columns above has 10 original data only, then
my output should be 5 columns of data with 10 entries each.

Thanks in advance,
Anshuman

--

Dave Peterson

Try recording a macro when you do it manually.

Follow those instructions on Debra's page while you're doing it.

anshu wrote:

Not able to figure it out...

I need to get past it using a macro as this step is in between a long
procedure...

So, somewhere bewteen the procedure, I will have a list stacked up
with 5 columns and unequal number of data in each column with some
repeat occurences ( no repeat between columns..all repeats are within
column)...

I need to write a macro so that the duplicates get deleted and I am
just left with 5 columns of unique data. Then I would count number of
data items in each column and name them differently...These names will
be used by my program later on to call this list...

Need Help

Thanks,
Anshuman

On Jul 16, 10:40 pm, Dave Peterson wrote:
Each column is separate and distinct from the other columns--duplicates between
the columns don't matter?

If that's true, you can use data|filter|advanced filter 5 times and copy the
visible cells to a new worksheet.

Debra Dalgleish explains it in more details:http://www.contextures.com/xladvfilter01.html#FilterUR



anshu wrote:

Hi All,

I am asking too many questions but so does a child who learns
something new :-)

I have 5 columns of data. Each columns has different number of data
starting row 2. Row 1 has the column heading.

Column 1 has 34 data (which may vary)
Column 1 has 64 data (which may vary)
Column 1 has 13 data (which may vary)
Column 1 has 11 data (which may vary)
Column 1 has 37 data (which may vary)

In each column, some of the data is duplicate.

I need to generate a list with all the duplicate entries removed.

Assuming each of the 5 columns above has 10 original data only, then
my output should be 5 columns of data with 10 entries each.

Thanks in advance,
Anshuman

--

Dave Peterson

--

Dave Peterson

Thanks Dave...

Got it figured out....

Anshuman


On Jul 17, 8:12 am, Dave Peterson wrote:
Try recording a macro when you do it manually.

Follow those instructions on Debra's page while you're doing it.



anshu wrote:

Not able to figure it out...

I need to get past it using a macro as this step is in between a long
procedure...

So, somewhere bewteen the procedure, I will have a list stacked up
with 5 columns and unequal number of data in each column with some
repeat occurences ( no repeat between columns..all repeats are within
column)...

I need to write a macro so that the duplicates get deleted and I am
just left with 5 columns of unique data. Then I would count number of
data items in each column and name them differently...These names will
be used by my program later on to call this list...

Need Help

Thanks,
Anshuman

On Jul 16, 10:40 pm, Dave Peterson wrote:
Each column is separate and distinct from the other columns--duplicates between
the columns don't matter?

If that's true, you can use data|filter|advanced filter 5 times and copy the
visible cells to a new worksheet.

Debra Dalgleish explains it in more details:http://www.contextures.com/xladvfilter01.html#FilterUR

anshu wrote:

Hi All,

I am asking too many questions but so does a child who learns
something new :-)

I have 5 columns of data. Each columns has different number of data
starting row 2. Row 1 has the column heading.

Column 1 has 34 data (which may vary)
Column 1 has 64 data (which may vary)
Column 1 has 13 data (which may vary)
Column 1 has 11 data (which may vary)
Column 1 has 37 data (which may vary)

In each column, some of the data is duplicate.

I need to generate a list with all the duplicate entries removed.

Assuming each of the 5 columns above has 10 original data only, then
my output should be 5 columns of data with 10 entries each.

Thanks in advance,
Anshuman

--

Dave Peterson

--

Dave Peterson