Find value on two crateria

[harilalkmr]

Hi,

I have data like below.
City sales Date
Bangalore 300 9/12/2014
Ranchi 200 9/12/2014
Ranchi 500 9/12/2014
Bokaro 400 9/12/2014

my problem is how to find which city has highest sale on 9/12/2014

[berlan]

Duplicate thread, http://www.excelforum.com/excel-gene...-crateria.html