Ok Thanks.
I got that all done, and the results are 4 duplicates, and the results on the sheet 1 is that the numbers are showing on players names 1 row below where they actually go with the correct name.
I pasted the formula it gave me in Column I, Row 4, where the first row names are.
Also how do I change the duplicate names, just manually in the Scrape sheet or Sheet 1, just don't want to make a mistake, lol.
Edit - I did change the formula to 1 row lower and the names are in the correct row, will the #NA, stay in the rows of names that don't have updates, not a problem, just asking, Thanks.
I have to say this amazing, yeah excited!
Last edited by rogcar75; 08-25-2014 at 08:41 AM.
|