Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
143
Views
Topic starter
Dears,
hope you are fine,
I want a formula (column C) which will update the cell based on the category which I will select in column B.
So, I want the first number to be default for example if the category is Containers then the asset should be 200000.
next, during the filling if I select again category, the next asset ID to be 200001.
in attach you'll find the table.
Thanks in advance!
Posted : 14/03/2023 10:55 am
Hi,
No file attached. Click on the Start Upload button after selecting the file.
regards
Phil
Posted : 14/03/2023 7:23 pm