darkbluecat
New Member
- Joined
- Jan 7, 2021
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
Hi,
I've had a look through past posts and can't find anything relating to what I'm trying to do or where to start with it.
So I have five categories, including an unidentified category (which relates to one specific supplier category in another column in my raw data), so in these 5 categories, I want to do the sum of the unidentified stuff moved into an even 50/50 split into other pre existing categories (e.g. if unidentified, sum is split 50% one category, 50% the other category).
I'm just not sure what calculation/action would work, but it needs to be automated.
There's a total 144 cells in the unidentified category- is there a way to sum 72 of these into one pre existing category and the other 72 in another pre existing category?
Sorry, can't provide any more information as work stuff.
I've had a look through past posts and can't find anything relating to what I'm trying to do or where to start with it.
So I have five categories, including an unidentified category (which relates to one specific supplier category in another column in my raw data), so in these 5 categories, I want to do the sum of the unidentified stuff moved into an even 50/50 split into other pre existing categories (e.g. if unidentified, sum is split 50% one category, 50% the other category).
I'm just not sure what calculation/action would work, but it needs to be automated.
There's a total 144 cells in the unidentified category- is there a way to sum 72 of these into one pre existing category and the other 72 in another pre existing category?
Sorry, can't provide any more information as work stuff.