want to get highest sales qty and sales person name within specified dates

in C21:

=MAX(INDEX(($B$2:$B$17>=$A$21)*($B$2:$B$17<=$B$21)*($D$2:$D$17),0))

in D21:

=IFERROR(INDEX($A$2:$A$17,MATCH($C$21,$D$2:$D$17,0)),"-")

Hi devawad,

See if the attached helps with a good answer.

I need more information than "it is not working properly for me". Give me a sample file that shows what you want to arrive at. You should also change some values so there is a largest one.

this approach requires a helper column, see if it meets your needs:

icestationzbra, I would also go with helper column.
Here is solution with Pivot Table that doesn't exactly match users requirements but might be interesting solution for cataloging bigger amount of data:

You can do this without a helper column if you want, with this "array formula" in C15

=MAX(SUMIFS(D2:D11,B2:B11,">="&A15,B2:B11,"<="&B15,A2:A11,A2:A11))

confirmed with CTRL+SHIFT+ENTER

and then this formula (also array entered) in D15

=INDEX(A2:A11,MATCH(C15,SUMIFS(D2:D11,B2:B11,">="&A15,B2:B11,"<="&B15,A2:A11,A2:A11),0))

confirmed with CTRL+SHIFT+ENTER

see attached, I changed the dates to show how it works when you do that.....