Hyperlink and sorting my list?

[bhandari]

[TABLE="width: 673"]
<tbody>[TR]
[TD]26-07-17[/TD]
[TD]Minutes of Meeting[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/100[/TD]
[/TR]
[TR]
[TD]29-07-17[/TD]
[TD]Submission of Drawings in respect of Box Culverts and Retaining Walls[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/102[/TD]
[/TR]
[TR]
[TD]26-07-17[/TD]
[TD]Electrical Utility Shifting Bills[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/99[/TD]
[/TR]
[TR]
[TD]08-08-17[/TD]
[TD]Submission of working drawings in respect of pipe culverts[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/120[/TD]
[/TR]
[TR]
[TD]17-08-17[/TD]
[TD]Mobilization of Resident Engineer Mr.Birendar Kumar Singh[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/137[/TD]
[/TR]
[TR]
[TD]31-08-17[/TD]
[TD]Submission of Design reports and Drawings for ROB at chainage 139+465[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/151[/TD]
[/TR]
[TR]
[TD]05-09-17[/TD]
[TD]Pavement Design Report[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/156[/TD]
[/TR]
[TR]
[TD]12-09-17[/TD]
[TD]Regarding Slow Progress of Project[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/166[/TD]
[/TR]
[TR]
[TD]31-05-17[/TD]
[TD]India Cement-Company profile[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/11[/TD]
[/TR]
[TR]
[TD]12-09-17[/TD]
[TD]Regarding Modification of Percentage Weightage for stage Payment[/TD]
[TD]AA/GADAG/HH/NH-63/2070/2017-18/167[/TD]
[/TR]
</tbody>[/TABLE]
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. :[TABLE="width: 504"]
<tbody>[TR]
[TD="class: xl65, width: 504"]=TRIM(RIGHT(SUBSTITUTE(C2;"/";REPT(" ";255));255))[/TD]
[/TR]
</tbody>[/TABLE]


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