I have a worksheet, we can call it worksheet 1, that ranks name in column "A" and he or shes score in column "B". These score are driven from another date worksheet, worksheet 2, within the workbook. I would like have column A and B of worksheet 1 ranked automatically as the data is updated. Can this be done? What would be the best formula to insure accuracy?

Thanks,
Bryan