Hyperlink and sorting my list?

[bhandari]

26-07-17	Minutes of Meeting	AA/GADAG/HH/NH-63/2070/2017-18/100
29-07-17	Submission of Drawings in respect of Box Culverts and Retaining Walls	AA/GADAG/HH/NH-63/2070/2017-18/102
26-07-17	Electrical Utility Shifting Bills	AA/GADAG/HH/NH-63/2070/2017-18/99
08-08-17	Submission of working drawings in respect of pipe culverts	AA/GADAG/HH/NH-63/2070/2017-18/120
17-08-17	Mobilization of Resident Engineer Mr.Birendar Kumar Singh	AA/GADAG/HH/NH-63/2070/2017-18/137
31-08-17	Submission of Design reports and Drawings for ROB at chainage 139+465	AA/GADAG/HH/NH-63/2070/2017-18/151
05-09-17	Pavement Design Report	AA/GADAG/HH/NH-63/2070/2017-18/156
12-09-17	Regarding Slow Progress of Project	AA/GADAG/HH/NH-63/2070/2017-18/166
31-05-17	India Cement-Company profile	AA/GADAG/HH/NH-63/2070/2017-18/11
12-09-17	Regarding Modification of Percentage Weightage for stage Payment	AA/GADAG/HH/NH-63/2070/2017-18/167

<tbody>
</tbody>

In this list check Bold Numbers Those are not in chronological order..this list contains around 500rows
my intention to remove duplicates and make them in chronological order, as well i have pdf files in folder, which i want to link for C1
is ther any solution for this instead of giving hiperlink C1,C2,C3...C500?
i like to drag there are 500 links thats why

 

[bhandari]

Re: Can any one help me with Hyperlink and sorting my list?

any help it would be great

 

[Xerno]

Re: Can any one help me with Hyperlink and sorting my list?

Hi,

Assuming that the Hyperlinks are starting in cell C2

Try Formula i D2 (Not tested):
=RIGHT(C2,LEN(C2)-FIND("/",C2))

And then Sort D2 A - Z

 

[bhandari]

Re: Can any one help me with Hyperlink and sorting my list?

same values is coming ..not coming in chronological order
https://drive.google.com/open?id=0B-ZWlAv5DqaEall3Tk9PWnQ0czA

 

[Xerno]

Re: Can any one help me with Hyperlink and sorting my list?

Hi,

This might not be the best solution but might work to sort the hyperlinks

Try in D2 If the Hyperlink is in C2. :

=TRIM(RIGHT(SUBSTITUTE(C2;"/";REPT(" ";255));255))

<tbody>
</tbody>

Then in E2 add to give a leading "0":
=TEXT(D2;"000")

Now Sort E2 A - Z and it should be on chronological order based on the end on the hyperlink.
And you should be able to find duplicates and delete them.


For the PDF Files, im not really understand what you are trying to do, is it the information from the PDF you want in C1?

 

[bhandari]

Re: Can any one help me with Hyperlink and sorting my list?

Tnc for the formula.
hey i just need it with macro.
my intention to split the values from one sheet to another sheet