Order

[Leonidas75]

Hello

I am trying to get Top 5 sales between 2 dates such as : 1st October - 31st October

Excel tabs are as follows:

Salesperson - Sales - Date
John - 15 - 2nd October
Mary - 17 - 5th October
Steve - 10 - 17th October
Michelle - 11 - 23rd October
Gary - 22 - 15th October
James - 18 - 12th October

I don't want to use the rank function as the underlying data is extensive (above is just an example) and the months will be dynamic as well.

I was trying to use the LARGE function with multiple criteria without success (getting #num result) even when I change to array.

Ideally want to see the results in order = 22, 18, 17, 15, 11 and from there I will place index matches on salesperson and other required fields.

Assistance would be appreciated

 

[FormR]

I am trying to get Top 5 sales between 2 dates such as : 1st October - 31st October

Hi, can you make use of something like this?

Excel 2013/2016
	A	B	C	D	E
1	Salesperson	Sales	Date		Formula
2	John	15	02-Oct		22
3	Mary	17	05-Oct		18
4	Steve	10	17-Oct		17
5	Michelle	11	23-Oct		15
6	Gary	22	15-Oct		11
7	James	18	12-Oct
Sheet1

Cell Formulas
Range	Formula
E2	=AGGREGATE(14,6,$B$2:$B$7/(TEXT($C$2:$C$7,"MMMYYYY")="OCT2017"),ROWS(E$1:E1))

from there I will place index matches on salesperson and other required fields.

Beware of duplicates if it's possible they might exist.