Hi guys,
I am trying to set up a function that automatically generates the next unique available number in the same column but not in row order.
To activate the automatic calculation we use the validation function in an adjacent column (cell).
In few words...if (cell non blank), then (find larget number in column + 1)
OR......if (cell non blank), then (show next available unique number)
Product Number
AAA 7001
BBB 7003
EFG 7002
PKO ?????? (it should display 7004)
Please note: The order we activate the products is not sequential.
Thank you
Bookmarks