Quote Originally Posted by jhantoojha View Post
There are few errors in your sheet. You have added country for BAYFILE whereas the host is Bayfiles. This results error. Again rapidshare/filepost sometime creates links as https instead of http which was not taken into consideration. Moreover, Uploaded.to creates links as ul.to/upoaded.to. But you have created country name for Uploaded.

I have redesigned the sheets into more simple way so that any future errors can easily be identified. Everything is in Sheet1 (Few columns to be kept as hidden) and Sheet2 for Host-Country list. All formulas have been copied upto row 8000. So you have to copy onwards when you have reached A8000.

http://www.filefactory.com/file/c3e06f6/n/TV.xlsx

Check it and give feedback.
Quote Originally Posted by Lock Down View Post
http://www.mediafire.com/?c382cfb7dgbvq2w

There you go .. Had to modify one of the calculations..
Thanks Guys.....But if i want to add more hosts what do i need to do?

Simply Add Hostname in Sheet 2's A Column and Country in B or do i need to make any other changes?
Sushant Reviewed by Sushant on . Need Microsoft Excel Help Hi I Want Help with Excel...See is there any way which i can use to add Country for file sharing site automatically.. Suppose i m adding 4 Depositfiles.com 4Uploaded.to 4filesonic.com link in A Column I want country of Depositfiles.com,uploaded.to and filesonic.com to be added in Column B and that work should be automatic? is there any way to do that with Excel? Rating: 5