Finding MAX value IF ?

[kevin.denham]

I need to find the MAX value in column E but only checking those cells that have a "1" in their corresponding G column. Then I need to do the reverse, find the MIN value in column E, checking only those with a "0" in their corresponding G column.

In the attached files the resulting numbers should be those located in E16 (211) for the MAX and E15 (243.93) for the MIN. I just need to be able to have another cell find these values as this table is refreshed with more/less rows causing the location for the correct MAX and MIN to move up and down.

I'm also open to other ideas for finding these values reliably when they move up and down.

Big thanks to anyone who can help.

[Palmetto]

Max formula: {=MAX(IF(Table12[Bid]=1,Table12[Price]))}
Min formula: {=MIN(IF(Table12[Bid]=0,Table12[Price]))}

Or you could just use a Pivot Table.