HI Guys,
I've searched the forum for answers, but can't find one that solves my particular problem.
I have attached the spreadsheet.
Firstly, I need to find the Top 5 biggest sales across columns D, F, J, L; each of these columns have qualifying criteria ("AI", as opposed to "A", etc) in their corresponding columns (E, G, K, M). This data (amounts) then get inputted in a different sheet (Top 5...). i've played around with Large(if) as well as Large(or) statements, but no avail.

2ndly, I also need the matching Client Name added. ( I have played around with Index & Match, but they only seem to work if they have to match one column.
There are actually more columns, besides DFJ& L, there are 6 to be precise, but I am hoping this example I can just be adapted for all my regions.
Excel Functions for Top 5 wins.xlsx
Please can someone shed some light?
I hope I explained it correctly.
Many thanks