VLOOKUP and Max Function to return multiple values

[beaverx37]

I'm trying to see which day of the week had the most sales each month. Column A is # of Sales. I'm currently using this formula =VLOOKUP(MAX(A$44:A$50),A$44:B$50,2,FALSE)

Because this formula can only return one value, it will return "Sunday" since it is the first in column B with highest value, even though it is equal to "Tuesday"

How can I have it tell me Sunday and Tuesday both were the highest for that month?

 

[Fluff]

Hi & welcome to MrExcel.
Is this for Google Sheets or for Excel?

 

[beaverx37]

Hi & welcome to MrExcel.
Is this for Google Sheets or for Excel?

It's currently in a google sheet. But I use it in Excel too.

 

[AhoyNC]

For Excel 365 see formula in cell E46 and for Excel 2016 see formula in G46.
Can't help with Google sheet.

Book2
	A	B	C	D	E	F	G
44
45	Sales	January			Excel 365		Excel 2016
46	9	Sunday			Sunday		Sunday
47	3	Monday			Tuesday		Tuesday
48	9	Tuesday			Friday		Friday
49	3	Wednesday
50	4	Thursday
51	9	Friday
52	4	Saturday
Sheet1

Cell Formulas
Range	Formula
E46:E48	E46	=FILTER(B46:B52,A46:A52=MAX($A$46:$A$52))
G46:G50	G46	=IFERROR(INDEX($B$46:$B$52,AGGREGATE(15,6,(ROW($B$46:$B$52)-ROW($B$46)+1)/(MAX($A$46:$A$52)=$A$46:$A$52),ROWS($G$46:G46))),"")
Dynamic array formulas.

 

[Fluff]

It's currently in a google sheet. But I use it in Excel too.

Ok, how about, I think this should work in Sheets as well as Excel.

=TEXTJOIN(", ",,FILTER(B$44:B$50,A$44,A$50=MAX(A$44:A$50)))