Excel Small If Formula For Multiple Criterias

[hrayani]

Hello Friends,

I am using the below formula to extract the smallest value from the data

=SMALL(IF(($G$2=gsm_pc_weight_ref_no)*($J$2=gsm_pc_weight_design_color_name)*($H$2>=gsm_pc_weight_date)*($I$2<=gsm_pc_weight_date),gsm_pc_weight_value,""),ROW(1:1))

CTL+SHF+ENT


Cells H2 & I2 in the formula represents dates (From - To)

The problem I am having is when both dates are equal than the formula works fine.
But as soon as I change the From date or To date then the formula gives error #NUM !

Am I doing anything wrong

Any help would be appreciated.

 

[DanteAmor]

=IFERROR(SMALL(IF([COLOR=#ff0000](gsm_pc_weight_value>H4)[/COLOR]*(gsm_pc_weight_ref_no=$G$2)*(gsm_pc_weight_design_color_name=$J$2)*(gsm_pc_weight_date>=$H$2)*(gsm_pc_weight_date<=$I$2),gsm_pc_weight_value,""),1),"")[COLOR=#333333]
[/COLOR]

Let me know if there is a better way of doing this. I mean the added criteria marked in red for the unique values.

Best Regards,

Humayun

The solution seems very good to me.

 

[hrayani]

Dear DanteAmor & Marcelo


Thanks to both of you

Best Regards,

Humayun

 

[DanteAmor]

Dear DanteAmor & Marcelo


Thanks to both of you

Best Regards,

Humayun

You're welcome & thanks for the feedback.