Excel Formula Help
Hi all Im new to excel and was wondering if someone would be kind enough to
help me out.
The main worksheet consists of all the data, example: name and totals, I was
wondering if its possible when I create a new worksheet that it would list
the person name based on the highest to the lowest totals from the main
worksheet.
Main worksheet consists of:
Cell D2 :D60 = Names
Cell F2 :D69 = Totals
So in worksheet 2 it will automatically list the names based on the main
worksheet data is this possible?
|