I'm trying to track incrementing product numbers in excel as the products are created in 3 categories. Example of those product numbers would be Ballpoints, Rollerballs & Fountains, like this: BP0001, RB0023 & F0005. As a new product is created in one of the 3 categories, it would increase, such as BP0002, RB0024 & F0006.
Is there a way to use a Max or Maxif function to show in 3 different cells, what the max number for each of those products is?
Solved by C. Q. in 15 mins