HOW TO GET DESIRED OUTCOME USING EXCEL?

Hello, Don’t really know how to name this problem properly. Just made it more in a general sense rather than a specific one.

Here’s the problem, i’ve been testing out some formulas to see if i can produce my desired result of table of data but to no avail. Heres what i want to happen.

Using this table: Desired result:

1 aa 881 1 aa 881

2 ab 882 2 ab 883

2 ab 883 3 ac 884

3 ac 884 4 ad 886

4 ad 885 5 ae 889

4 ad 886

5 ae 887

5 ae 888

5 ae 889

 

It’s not really the table i’m working on, but it shows the idea of what i want to happen. 

The numbers can get up to as high as 500+, with some numbers not only having a duplicate but also a triplicate. 

Thanks for reading this. Hope to have a generous answer from anyone here.

By: GeDeon

One thought on “HOW TO GET DESIRED OUTCOME USING EXCEL?

  1. GeDeon

    Using this table:
    1 aa 881
    2 ab 882
    2 ab 883
    3 ac 884
    4 ad 885
    4 ad 886
    5 ae 887
    5 ae 888
    5 ae 889

    Desired result:
    1 aa 881
    2 ab 883
    3 ac 884
    4 ad 886
    5 ae 889

Leave a Reply

Your email address will not be published. Required fields are marked *