Q on LARGE function

  • Thread starter Thread starter Seanie
  • Start date Start date
S

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)))
 
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
 
Back
Top