Max Question

[MrData]

I have two columns of data. The column B contains the day of the week, whilst column E has a value.

I'm trying to get the Max value for a specific day (Tue) the day can appear any number of times.

Could someone oblige woth a formula?

 

[njimack]

=MAX(IF(B1:B6="Tue",E1:E6))

Enter with Ctrl+Shift+Enter

Adjust ranges to suit

 

[Aladin Akyurek]

I have two columns of data. The column B contains the day of the week, whilst column E has a value.

I'm trying to get the Max value for a specific day (Tue) the day can appear any number of times.

Could someone oblige woth a formula?

If month and year are of no interest...

And if days in column B are given just as text...

Control+shift+enter, not just enter:

=MAX(IF($B$2:$B$100="Tue",$E$2:$E$100))

If column B contains true dates...

Control+shift+enter, not just enter:

=MAX(IF(WEEKDAY($B$2:$B$100)=3,$E$2:$E$100))