Thread: Auto-increment numbers
View Single Post
 
Old 05-15-2021, 02:46 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Something like this?

=MAXIFS($B$1:B15,$A$1:A15,A16)+1
Attached Files
File Type: xlsx ExampleAR12.xlsx (9.8 KB, 8 views)
Reply With Quote