Latest Announcemnent
New thread
Status
Not open for further replies.
S

Sushant

Active Member
265
2009
38
0
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?
 
20 comments
Do you know the countries or are you wanting to get them from somewhere else.

If you know them then yes there it can be done so it fills the col automatically.
 
What do you mean by country - the country where downloads were made or else ? Can you give more details with the excel sheet ( if possible) ?
 
no i want to add the file Hosting Country not where the downloads made.....

http://www.mediafire.com/?iq7b9d171b2an5x

Download this file see in A Row i have all the links and in second row i have countries of file hosting site..i want to make it automatic....i just add the link and i will get Country of the hosting site in B Row.....
 
Hi mate i downloaded this file and just did copy paste of one deposit link from web but i did not got country name automatically in next row :-(..........sorry buddy bt i m noob in this work...i shall be very thankful to you if you could help me out with this...
 
I have just copied the formula upto the data in ColumnA. You have to copy the formula in the below cells. I think this is not the right place to discuss much on the subject. You contact me to my email address.
 
Thanx Lock Down. I thought Sushant could follow the hints and therefore left my sheet for him to design according to his choices. Yours will be of much help.
 
Last edited:
Lock Down said:
Here you go. I changed it to make it easier for you.
http://www.mediafire.com/?as6cv5ekaz5hcx5
Click to expand...

jhantoojha said:
Thanx Lock Down. I though Sushant could follow the hints and therefore left my sheet for him to design according to his choices. Yours will be of much help.
Click to expand...

yes Lock Down Thanks Yours one is working fine.....can you please tell me now how to add more countries and more hosts in this file?

---------- Post added at 08:10 AM ---------- Previous post was at 08:10 AM ----------
jhantoojha said:
I have just copied the formula upto the data in ColumnA. You have to copy the formula in the below cells. I think this is not the right place to discuss much on the subject. You contact me to my email address.
Click to expand...

Added You iN Gmail Mate......PM me when you come online :-)
 
Yes you can add it at Sheet2. You right click on Sheet1 tab below and Click on Unhide. It will unhide Sheet2. In Sheet2, add filehost in ColumnA and corresponding country in ColumnB. The formula has taken into consideration for 15 filehosts. If you like to add more filehosts, you will have to slightly change the formula. Suppose you are going to add 25 filehosts in total, Click on B1 in Sheet1. Go to the formula bar. You will see the formula as : ==IF(ISTEXT(A1),VLOOKUP(Sheet2!G1,Sheet2!A$1:B$15,2,0),""). As you have decided to make provision for 25 filehosts, simply change B$15 to B$25 and click enter. Now copy the formula of B1 to below say upto B4000 or more.
Lock Down may suggest for his alternative.
 
jhantoojha said:
Yes you can add it at Sheet2. You right click on Sheet1 tab below and Click on Unhide. It will unhide Sheet2. In Sheet2, add filehost in ColumnA and corresponding country in ColumnB. The formula has taken into consideration for 15 filehosts. If you like to add more filehosts, you will have to slightly change the formula. Suppose you are going to add 25 filehosts in total, Click on B1 in Sheet1. Go to the formula bar. You will see the formula as : ==IF(ISTEXT(A1),VLOOKUP(Sheet2!G1,Sheet2!A$1:B$15,2,0),""). As you have decided to make provision for 25 filehosts, simply change B$15 to B$25 and click enter. Now copy the formula of B1 to below say upto B4000 or more.
Lock Down may suggest for his alternative.
Click to expand...


Thanks mate it is really helpful for me now.......and Thanks to Lock Down also...:-)

---------- Post added at 11:47 AM ---------- Previous post was at 10:40 AM ----------

Buddy i have one problem in it when i m adding shareflare and mediafire link then i m getting #N/A something this kind of error :-ss
 
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.
 
jhantoojha said:
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.
Click to expand...

Lock Down said:
http://www.mediafire.com/?c382cfb7dgbvq2w

There you go .. Had to modify one of the calculations..
Click to expand...

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?
 
The file I provided you is meant for 200 filehosts and that's enough, I think. If you need more, simply add host and country in Sheet2 and change the formula as suggested before.
Click on F1 in Sheet1. At formula bar, you see the formula as =IFERROR((VLOOKUP(E1,Sheet2!A$1:B$200,2,0)),""). Here B$200 means for 200 filehosts. So if you need for 300 filehosts, change 200 to 300 and hit enter. Now copy the formula at F1 to the end say F8000 or more.
 
Status
Not open for further replies.
Back
Top