maximum of cells containing same value in two other columns

Hi all,

I want to calculate the min and maximum of cells containing same value in two other columns.

I used the formula below but it returns 0 whenever the frequency is not included (i.e the number of inhabitants, as in the attached sheet).

IFERROR(IF(ISNUMBER(G$2),MIN(IF(($F3=$A$2:$A$31)*(G$2=$B$2:$B$31),$C$2:$C$31)),MIN(IF($F3=$A$2:$A$31,$C$2:$C$31))),"")

Kindly find attached the data file

Any help will be appreciated.

Thanks.

cdad

with PowerQuery (Get&Transform)

is that what you want?

Thanks all. I really appreciate all your responses. I was successfully able to apply DaddyLongleg's formula.