A possible solution for your last post.
I added 3 helper columns, and a table on same sheet, which demonstrates, how to get info about previous use of same Task Card number. You can add this info into Table tTasks instead, or you can use the logic of my example to get this info into some of your reports (to keep several Tables on same sheet permanently is not very good practice). In case the Task Card was not used previously, the formula in PrevTCardRow returns an empty string.
And columns for year, month and week numbers are also helper columns, and needed only when you design reports. After this is done, you can hide them (I colored headers for all such columns orange).
NB! As you see, those formulas don't depend on position of entry in table - i.e. you can sort your data entry table in any way, and the results remain same!
The only limitation with current formulas is, you can't have the same Task Card number on same date more than once! But of-course it is possible to change formulas in columns TCardOrd and PrevTCardRow so, that the task cards are numbered separately for some additional condition (e.g. by column Processor - then the formula in TCardOrd returns e.g. the order number of given card for this card and processor)
|