@Andrewattheshore
Without a decent excel file (without sensitive data, please)
where you can explain your plans in detail based on this file, it is very difficult to follow you.
The translation is not always correct.
Of course, knowing the Excel version and the operating system is an advantage for everyone.
Nonetheless, I am sending you some examples via SUBTOTAL in a file (and as a Link for Info)
where you can add your own data if it suits you.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
