I am a novice at excel and I am attempting to learn on the go while building a spreadsheet capable that I am capable of using to run an online fantasy football team I use, so I am sure I will be asking multiple questions the next few weeks while I am working on this. So here goes:
1. Can you use excel to pull certain information of the web? Say you have a web page with a list of information like player stats and I only want to pull a section of that info off that page can I do that and how?
2. I am using cell V7 to input the formula but I want cell V7 to tell me if the number in U7 is greater than or equal to the individual #'s in cells U7-U40 and I would like it to put a 1,2,3 in the cells of V7-V40 for the three highest numbers is this possible?
I am really sorry for the bother.
Bookmarks