Good Day to all
I am trying to replace below formulas with a macro code.
=Min(if($C$7:$C$14940=$N7;if($D$7:$D$14940=M$7;$F$7:$F$11940)))
=Max(if($C$7:$C$14940=$N7;if($D$7:$D$14940=$M7;$F$7:$F$14940)))
I have 2 criterias
Criteria 1 : Plate Number like (PN AU 2095)
Criteria 2 : Period like (2018/01)
I try to find max or min values from Column (F7:to last Row) with multiple criteria.
Column (D7:to last row)= Plate Numbers
Column (C7:to last row)= Periods
Column (F7:to last row)= Kilometers (where the code must get the max or min "Km" regarding to these 2 criteria.)
I have atatched my workbook to this message.
Thanks for any help from now.
This question has been also poted at this forum too ; https://www.mrexcel.com/forum/excel-...criterias.html
Bookmarks