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)

Attached Files

TaskInfo.xlsx (30.0 KB, 6 views)

Thanks, again, ArviLaanemets!

Trying it now. I figured helper columns would be needed as they are the only way I have been able to perform other tasks in Excel.

I will let you know!

Oh joy. The boss just saw my new rendition of this project (based on your example) and she chewed me out. She wants it exactly as it was, with multiple tabs, etc.

It was working, too...

I guess it's back to the drawing board! Thanks again for your help...

OH! - Unless of course you can still help me figure this out with the original structure?!

The positive effect of this is, you don't have to worry about having to work on something You are always needed!

I myself prefer to work on something new instead updating the same file for years.

I had a case, where I got a task to update the Excel file I created about 20 years earlier, as there was a new workplace added. All those 20 year the file was in use without any need for updates so long (users added new data daily, and in case the file did slow down, removed some bulk amount of obsolete data running a procedure)

ArviLaanemets

Yea, right! But I am a Technical Writer, NOT an Excel expert - and yet, you do one thing in Excel and suddenly that's everything you do!

Why make things easy when complicated things also work

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post