Serial Numbers Based Upon Another Cell
Closed
lkazempour
Posts
1
Registration date
Wednesday March 20, 2019
Status
Member
Last seen
March 20, 2019
-
Mar 20, 2019 at 01:38 PM
Blocked Profile - Mar 21, 2019 at 08:28 AM
Blocked Profile - Mar 21, 2019 at 08:28 AM
I have a spreadsheet with owner and tenant information, along with their vehicle information. In the column that indicates if they are an owner, I have used data validation to limit the entry to either "O" or "T" that I want to incorporate into the serial number along with the current year. So, it should read something like "O-2019-01" or "T-2019-01" and increase by one for each entry and be static if the list changes, for example, by filtering. I cannot seem to locate exactly the right information to accomplish what I am trying to accomplish.
Related:
- Serial Numbers Based Upon Another Cell
- Nic serial number - Guide
- Nero 6 serial number - Software Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- If a cell has text then return value ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum