Q on LARGE function

[Seanie]

I have the formula below which returns the largest sales day, but what
if the largest day covered two days, say Monday & Friday, how could I
build that in to my formula i.e. Result could be more than one value?

=IF(R197=0,"","Biggest Sales Day = "&INDEX(M188:M194,MATCH(LARGE
(S188:S194,ROW(A1)),S188:S194,0)))

 

[Bernie Deitrick]

Seanie,

As long as the data is in consecutive cells, array enter a formula like:

=IF(R197=0,"","Biggest 2 Days of Sales started on =
"&INDEX(M188:M194,MATCH(LARGE(S188:S193+S189:S194,ROW(A1)),S188:S193+S189:S194,0)))

HTH,
Bernie
MS Excel MVP