Quote:
Originally Posted by p45cal
=MINIFS(Table1[OR No.],Table1[OR No.],">=" & FLOOR(Table1[@[OR No.]]-0.1,50))
this is to cater for when the Or. No. was an exact multiple of 50.
|
Could you please check cell k 41 in the attached sheet? One pad ended at 529050 while the next pad started at 529051. The formula should return 529051 as the minimum number issued for pad 529051 to 529100 not 529050. Th same holds true with pad 529101.
Thank you.