Is it possible to do something like this in Excel? Like a list of active rows with an ordinal number in them.
There is a column B. It needs to show an ordinal number which represents the active row in the worksheet. Look at the image.
If the row is inactive, then column B will not have an ordinal number. Now, when I delete some ordinal number from the column B, the ordinal order has to update accordingly. Let's say I remove B7 cell text, how can I make column B updates its values. Look at the image.
Is it possible to do it in a simple way, without having to write a lot of script code?
PS. I am not an excel expert so it would be great if there is a simple solution via Excel's embedded formulas. :) PPS. this function is similar to Word's numbered list. If I delete any list item, subsequent elements will update its values accordingly.
EDIT
Column A lists all tasks from 1 to X. Column B lists active tasks. They are ordered by its status (active inactive). When I finish a certain task (example the 7th task), I just delete its value in column B and then manually fix all subsequent numbers. This way I know how many active tasks I have and which ones are active.
Please tell if it is still unclear and which part needs more explanation!!!
PS. Tasks are described in columns C,D and E, but that part was not relevant here.