Hi,

Been a member for a few months now and I can't find the answer to this anywhere.

I got a medium sized quality database (in Excel - i know) that has these columns (plus some more)

Name (Col A)
Date (Col G)
Error Reason (Col E)
Week # (Col O)
Week # & Name (Concatenated) (Col R)

What I want without using a pivot table or VBA if possible is to be able to say tell me the top 3 error reasons for person X for week num X. I know this can be done easily with a pivot table but I'm trying to stay away from that for ease of use reasons.

I've tried sumproduct, rank & countif with no luck.

Any help would be greatly received!

Thanks,

Scott