Max or Large no to be found using multiple conditions

[mahen]

Hi All,


I need a formula as mentioned below. Many thanks for your help in advance

Based on column b it needs to filter the data in column A and provide me the Max value in column C, Example for Monday the value in column C should be 66.

A B C
12 Monday
73 Tuesday
45 Wednesday
27 Wednesday
66 Monday
51 Tuesday
58 Wednesday
34 Monday
14 Tuesday
81 Wednesday

 

[abmati]

It is possible easily if u combine columns B,C and D as under:

Regards,

Mati

 

[abmati]

Excel Workbook
	A	B	C	D	E
1	12	Monday	Week1	Jan	JanWeek1Monday
2	73	Tuesday	Week1	Jan	JanWeek1Tuesday
3	45	Wednesday	Week1	Jan	JanWeek1Wednesday
4	27	Wednesday	Week1	Jan	JanWeek1Wednesday
5	66	Monday	Week2	Feb	FebWeek2Monday
6	51	Tuesday	Week1	Jan	JanWeek1Tuesday
7	58	Wednesday	Week2	Feb	FebWeek2Wednesday
8	34	Monday	Week2	Feb	FebWeek2Monday
9	14	Tuesday	Week2	Feb	FebWeek2Tuesday
10	81	Wednesday	Week2	Feb	FebWeek2Wednesday
11	67	Monday	Week3	March	MarchWeek3Monday
12	34	Tuesday	Week2	Feb	FebWeek2Tuesday
13	89	Wednesday	Week3	March	MarchWeek3Wednesday
14	23	Wednesday	Week3	March	MarchWeek3Wednesday
15	12	Monday	Week3	March	MarchWeek3Monday
16	45	Tuesday	Week3	March	MarchWeek3Tuesday
17	78	Wednesday	Week2	Feb	FebWeek2Wednesday
18	56	Monday	Week1	Jan	JanWeek1Monday
19	34	Tuesday	Week3	March	MarchWeek3Tuesday
20	23	Wednesday	Week1	Jan	JanWeek1Wednesday
Sheet1

in F2 cell {=MAX(IF(E1:E20=E1,A1:A20))}