Thread: [Solved] Last number issued in an invoice pad
View Single Post
 
Old 08-12-2021, 02:30 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
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
In your file in cell F3:
Code:
=MINIFS(Table1[OR No.],Table1[OR No.],">=" & FLOOR(Table1[@[OR No.]],50))
copied down gives the smallest number in a batch.
In cell G3:
Code:
=MAXIFS(Table1[OR No.],Table1[OR No.],"<=" & CEILING(Table1[@[OR No.]],50))
copied down gives the largest.
Reply With Quote