I have a very large spreadsheet that tracks times. I have the formulas
figured out fot the wait times that I need but I need to break them down by
individual. There are approximately 15 different physicians listed in this
spread sheet. I have a separate spreadsheet that I want to average the times
for each physician.

Example:

Physician 1 "time to see physician" "wait time" "elapsed time"
Physician 3 "time to see physician" "wait time" "elapsed time"
Physician 1 "time to see physician" "wait time" "elapsed time"
Physician 4 "time to see physician" "wait time" "elapsed time"
Physician 2 ....... and so on.

There are about 3000 entries one each spread sheet. How can I get the
Average Wait Time for Physician 1, Physician 2, etc. without having to sort
the sheet by physician. Is there a formula that can be used?

Thanks for any help.