ashishvijayvargiya
New Member
- Joined
- Jun 19, 2012
- Messages
- 1
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.
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.