different ID numbers in the same column

[locolindo]

Hi there,
I want to log ID numbers for two types of events: educational events (E0001, E0002, E0003.....and so on ) and non-educational events (NE0001, NE0002, NE0003.....and so on )), such that I would have a list that shows both in the same column in the following manner: E0001, E0002, NE0001, E0003, NE0002 and so on. The educational or non-educational events are defined in another column as a Yes/No dropdown list ("Educational?").

In other words, I need something to add to the educational events or the non-educational events and be able to increment them separately and alternatively relative to their own occurrence. I tried palying around with ROW() and COUNTIF() but with no success.

Best
locolindo

 

[NeonRedSharpie]

If you reorder the list, do the IDs change? How are the IDs being entered? On row insert?

 

[locolindo]

Hi NeonRedSharpie,
The IDs would correspond to unique records (rows) and as such, I would not want them to change if I reorder the list.
locolindo