View Single Post
 
Old 08-14-2021, 04:03 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

If you need to know the lowest Or. No used in a pad (you didn't ask for it in your narrative but did in your sample file) you may need a tweak to the formula I gave for that to:
=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.
Reply With Quote