Hi All. I have a some number ranges that I need to reduce down taking the
number and another variable into consideration. For example, the following
list:

1234 A
123 A
12 B
12345 A

can all be reduced down to:

12 B
123 A

Is there a way to do this in excel so that it goes through the list and
shortens a list down so that it contains only unique entries?

thanks!

Hi Jas,

Without VBA, Sort using the second cloumn as the primary
key and the first column as the secondarykey. Then apply the
Advanced Filter to the second column, selecting the Unique
values option.

If you need to automate this, turn on the macro recorder while
you perform these steps manually,


---
Regards,
Norman



"Jas" wrote in message
...
Hi All. I have a some number ranges that I need to reduce down taking the
number and another variable into consideration. For example, the
following
list:

1234 A
123 A
12 B
12345 A

can all be reduced down to:

12 B
123 A

Is there a way to do this in excel so that it goes through the list and
shortens a list down so that it contains only unique entries?

thanks!

I dont think this will work because I need it to keep shortening the
combination of the 2 fields until it reaches the lowest common combination.
For example, the list given below:

Column A Column B
001264537 276
001264538 276
001264539 276
001264581 276
001264582 276
001264583 276
001264584 276
001264729 276
001264772 276
001340277 276
001340332 276
001340344 276
001340473 276
001340474 276
001340998 276

would become just 2 entries 001264 276 and 001340 276 (minimum digit length
of column A is 6 characters)

Thanks

"Norman Jones" wrote:

Hi Jas,

Without VBA, Sort using the second cloumn as the primary
key and the first column as the secondarykey. Then apply the
Advanced Filter to the second column, selecting the Unique
values option.

If you need to automate this, turn on the macro recorder while
you perform these steps manually,


---
Regards,
Norman



"Jas" wrote in message
...
Hi All. I have a some number ranges that I need to reduce down taking the
number and another variable into consideration. For example, the
following
list:

1234 A
123 A
12 B
12345 A

can all be reduced down to:

12 B
123 A

Is there a way to do this in excel so that it goes through the list and
shortens a list down so that it contains only unique entries?

thanks!

Hi Jas,

My suggestion works for me using the data and the scenario
originally described by you.

I do not understand the new data taht you show or the results
which you indicate.

More particularly, you statement:

would become just 2 entries 001264 276 and 001340 276 (minimum digit
length
of column A is 6 characters)

is unclear to me, even after rereading it,

---
Regards,
Norman



"Jas" wrote in message
...
I dont think this will work because I need it to keep shortening the
combination of the 2 fields until it reaches the lowest common
combination.
For example, the list given below:

Column A Column B
001264537 276
001264538 276
001264539 276
001264581 276
001264582 276
001264583 276
001264584 276
001264729 276
001264772 276
001340277 276
001340332 276
001340344 276
001340473 276
001340474 276
001340998 276

would become just 2 entries 001264 276 and 001340 276 (minimum digit
length
of column A is 6 characters)

Thanks

"Norman Jones" wrote:

Hi Jas,

Without VBA, Sort using the second cloumn as the primary
key and the first column as the secondarykey. Then apply the
Advanced Filter to the second column, selecting the Unique
values option.

If you need to automate this, turn on the macro recorder while
you perform these steps manually,


---
Regards,
Norman



"Jas" wrote in message
...
Hi All. I have a some number ranges that I need to reduce down taking
the
number and another variable into consideration. For example, the
following
list:

1234 A
123 A
12 B
12345 A

can all be reduced down to:

12 B
123 A

Is there a way to do this in excel so that it goes through the list and
shortens a list down so that it contains only unique entries?

thanks!

What I need it to do is to keep taking off a digit from the right of the data
in column A until the combination of column A and B is unique. The problem
is not that I cant find unique entries, the proble is that I need to find the
"Parent" of a set of numbers. so the parent of the list below (based on 2
variables) is 001264 and 001340. These both have a column B value of 276.

Does this make any more sense?

"Norman Jones" wrote:

Hi Jas,

My suggestion works for me using the data and the scenario
originally described by you.

I do not understand the new data taht you show or the results
which you indicate.

More particularly, you statement:

would become just 2 entries 001264 276 and 001340 276 (minimum digit
length
of column A is 6 characters)

is unclear to me, even after rereading it,

---
Regards,
Norman



"Jas" wrote in message
...
I dont think this will work because I need it to keep shortening the
combination of the 2 fields until it reaches the lowest common
combination.
For example, the list given below:

Column A Column B
001264537 276
001264538 276
001264539 276
001264581 276
001264582 276
001264583 276
001264584 276
001264729 276
001264772 276
001340277 276
001340332 276
001340344 276
001340473 276
001340474 276
001340998 276

would become just 2 entries 001264 276 and 001340 276 (minimum digit
length
of column A is 6 characters)

Thanks

"Norman Jones" wrote:

Hi Jas,

Without VBA, Sort using the second cloumn as the primary
key and the first column as the secondarykey. Then apply the
Advanced Filter to the second column, selecting the Unique
values option.

If you need to automate this, turn on the macro recorder while
you perform these steps manually,


---
Regards,
Norman



"Jas" wrote in message
...
Hi All. I have a some number ranges that I need to reduce down taking
the
number and another variable into consideration. For example, the
following
list:

1234 A
123 A
12 B
12345 A

can all be reduced down to:

12 B
123 A

Is there a way to do this in excel so that it goes through the list and
shortens a list down so that it contains only unique entries?

thanks!