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
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