Conditinal Sorting

[torkunc]

Hi everyone,

In colomn A, I have Data like This:

TİP-1

TİP-2

TİP-5

TİP-5

TİP-5

TİP-9

TİP-9

TİP-10

<colgroup><col></colgroup><tbody>
</tbody>

As you see some are listed twice and some are three times...

I want to sort them in Colomn B with increment but if data repeats in colomn A, the increments should repeat itself in colomn B. Like this:
A B
------ ------
TİP-1 TİP-1
TİP-2 TİP-2
TİP-5 TİP-3
TİP-5 TİP-3
TİP-5 TİP-3
TİP-9 TİP-4
TİP-9 Tip-4
Tip-10 Tip-5

How can make it by formula?

 

[torkunc]

can anyone please help, it is sth urgent...

 

[torkunc]

Come on, still waiting the answer...

Thnx in advance.

 

[shuklaankur281190]

come on, still waiting the answer...

thnx in advance.

try this one with ctl+shift+enter

=index($a$1:$a$13, match(small(countif($a$1:$a$13, "<"&$a$1:$a$13), row(1:1)), countif($a$1:$a$13, "<"&$a$1:$a$13), 0))

 

[torkunc]

Thanks shuklaankur281190, however it does not give the correct answers when I drag & down:

Data	Answer	Your Formula
TİP-1	TİP-1	TİP-1
TİP-2	TİP-2	Tip-10
TİP-5	TİP-3	TİP-2
TİP-5	TİP-3	TİP-5
TİP-5	TİP-3	TİP-5
TİP-9	TİP-4	TİP-5
TİP-9	Tip-4	TİP-9
Tip-10	Tip-5	TİP-9

<tbody>
</tbody>

 

[shuklaankur281190]

Try this on
="TIP"&"-"&SMALL(VALUE(RIGHT($A$2:$A$15,LEN($A$2:$A$15)-FIND("-",$A$2:$A$15))),ROW(1:1))

 

[shuklaankur281190]

List	{="TİP"&"-"&SMALL(VALUE(RIGHT($A$2:$A$16,LEN($A$2:$A$16)-FIND("-",$A$2:$A$16))),ROW(1:1))}
TİP-1	TİP-1
TİP-2	TİP-1
TİP-5	TİP-2
TİP-5	TİP-3
TİP-5	TİP-3
TİP-9	TİP-5
TİP-9	TİP-5
TİP-10	TİP-5
TİP-3	TİP-5
TİP-3	TİP-9
TİP-15	TİP-9
TİP-5	TİP-10
TİP-1	TİP-11
TİP-11	TİP-15
TİP-15	TİP-15

<colgroup><col><col></colgroup><tbody>
</tbody>

Now check , i think it is working good

 

[torkunc]

My dear friend, I appreciate your effort but still it does not make what I am trying to.

Data	Answer	Your Reply
TİP-1	TİP-1	TİP-1
TİP-2	TİP-2	TİP-2
TİP-5	TİP-3	TİP-5
TİP-5	TİP-3	TİP-5
TİP-5	TİP-3	TİP-5
TİP-9	TİP-4	TİP-9
TİP-9	TİP-4	TİP-9
Tip-10	TİP-5	TİP-10

<tbody>
</tbody>

Maybe it is because of my English; I'll try to express again.

On A Colomn the data has some dublicates. I am trying to put an increment from A to Z. If you examine Answer Colomn above, you see that

1) it takes Type 1 and Type 2 as it is (since they dont have dublicates).
2) when it comes Type 5, as it has 3 times dublicates, it puts the next increment (this time 3) to the all Type-5 (so they turn into Type-3)
3) same also for Type 9. Since there are 2 x Type 9, it puts the next increment (now it is 4) to the both Type 9s (so they turn into Type-4)
5) Next row, it takes Type-10 and convert it to Type-5 (as increment is now 5)

Thanks for your effort and time...

 

[shuklaankur281190]

how much row you have???? or you can send your file once to me on my mail id shukla.ankur281190@gmail.com...

 

[torkunc]

how much row you have????

I have from A1 to A2584...

But in this example A1 to A8...