Autofill data

[mayurpatil]

Hi,

I have sheet in which have a table like this.

ID No. of times Priority index
a 5 15.58
b 10 14.44
c 2 7.6
d 10 6.46
e 5 2.28


I want to fill another column with the ids given in ID column , one below the other on basis of priority but the no. of times only mentioned in the No. of times column , can any function help this. or any software .Find the excel sheet attachedAutofill.xlsx


Thanks in advanvce,

Mayur

[tahi.laci]

I'm not sure what you mean by 'on basis of priority' but if you mean sorting by that, you can just look at an other thread on sorting, because that's done quite frequently.

Putting IDs under each other a variable times: (not 0)

I would use three helping columns for this:
D: plain ascending numbers (1,2,3...)
E: count how many times was the current ID already displayed: E2 =COUNTIF(F2:F$2,F2)
F: the rowNo of the actual IDs in the original table: F2 = 1 (plain number)
F3 =IF(E2=INDEX(B:B,MATCH(F2,D:D,0),1),F2+1,F2)
G:the actual ID: G2=INDEX($A$2:$A$6,F2,1)

P.S. I had difficulty finding out what you need it would be easier if you gave me the expected values entered manually.