First and foremost, are you using Excel 365? If not, I suggest you change; with the type of tasks you are undertaking, you should be able to recover the cost of a license every week in saved time.
The formulas I used for the tables were
You may observe that this bears little resemblance to traditional spreadsheet working. That observation would be correct.
Alongside the traditional methods of Excel, a completely different functionality has arisen that bears little similarity to the old.
Your words are correct
But it has to work in all computers, so it is not possible to spend so much. But 365 is available for one computer and not for other computers.
Then there is a little problem.
But the formula you wrote works very well. Thank you for your intelligence, skill, patience and advice