Finding Min Value Based on Multiple Criterias

[ashishvijayvargiya]

Hi There,

I tried find a lot over the web but no luck for this problem.

I can not use pivot tabel for this and I am required find a Minumum value based on to creterias i.e. I have 3 columns

(Column names)Value, Class (A,B&C), Location

Now I need minimum number from column "Value" based on Column "Class" (A) and "Region"(India) - I have thousands of records. This could done if excel had provided Minifs (like "Sumifs")

Please help me.

 

[Aladin Akyurek]

Hi There,

I tried find a lot over the web but no luck for this problem.

I can not use pivot tabel for this and I am required find a Minumum value based on to creterias i.e. I have 3 columns

(Column names)Value, Class (A,B&C), Location

Now I need minimum number from column "Value" based on Column "Class" (A) and "Region"(India) - I have thousands of records. This could done if excel had provided Minifs (like "Sumifs")

Please help me.

Control+shift+enter, not just enter:

=MIN(IF(ClassRange="A",IF(RegionRange="India",ValueRange)))