I am convinced that the act of thinking logically cannot possibly be natural to the human mind. If it were, then... our species would not have taken several millennia to figure out the scientific method.
1. You will need a VLookup [http://www.599cd.com/tips/excel/vlookup/]
2. The Rank function will be useful [http://www.599cd.com/tips/excel/rank-function/]
3. You'd probably be better off migrating the data to Access as this is the program better suited to your type of calculations. It is possible to do in Excel, Check out the Intermediate tutorials, Excel 220 onwards Data Lists [http://www.599cd.com/site/courselist/excel/excel220/]
Hope this helps you get started, Post back if you need any further help.
Alex
Reply from Richard Rost:
Alex, thanks for the excellent answer. Also FYI, I don't have the "BBOARD" style [hyperlinks] built into my Forums (although I should) but you can type in normal hyperlinks in straight HTML and they will work.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
