Conditinal Sorting

[torkunc]

Hi everyone,

In colomn A, I have Data like This:

[TABLE="width: 87"]
<colgroup><col></colgroup><tbody>[TR]
[TD]TİP-1[/TD]
[/TR]
[TR]
[TD]TİP-2[/TD]
[/TR]
[TR]
[TD]TİP-5[/TD]
[/TR]
[TR]
[TD]TİP-5[/TD]
[/TR]
[TR]
[TD]TİP-5[/TD]
[/TR]
[TR]
[TD]TİP-9[/TD]
[/TR]
[TR]
[TD]TİP-9[/TD]
[/TR]
[TR]
[TD]TİP-10[/TD]
[/TR]
</tbody>[/TABLE]

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?

 

[shuklaankur281190]

then you must edit the formula and change the range $A$1:$A$2584 every where

 

[torkunc]

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

Hi again,

I just send you the mail.

Thnx a lot.

 

[shuklaankur281190]

please check ur mail box

 

[shuklaankur281190]

finally i understood you question now please try below formula.

="TIP-"&SMALL(IFERROR(VALUE(RIGHT(A:A,LEN(A:A)-FIND("-",A:A))),""),ROW(1:1))