Probably you may be interested on another way to create unique row identifiers for certain shift on certain date - a dynamic named list, which allows enter only next sequential number for any row in table which match certain grouping conditions. I had to add 2 additional helper columns (LastSR and NextSR), and to create a dynamic Named Range (lNextSR), which is used as source range for Data Validation List in column ShifRow. In case date and shift cells are filled for active row, the data validation list allows enter only the next sequential number for this shift on this date. When either date or shift is undetermined, the string NextSR is only choice - to remind to fill 2 previous fields.
NB! In case you delete some ShiftRow value which isn't the last one, you can't enter the deleted number into this cell. To restore previous numbering, you have to clear all ShiftRow values for this shift and date, bigger than deleted one, and then refill them all in proper order.
|