May 10 2022 02:50 AM
Hi everyone
I am hoping if someone could help/advise with this fiddly problem I'm having on the attached. I have a formula in Sheet2 which is very effectively tracking fictitious donations based on selections made in Sheet1. My only issue with this is that if you look cells C4 and C10, it duplicates the 'donation' amount. This could potentially skew my data and vastly overestimate.
My question is; is it possible that this formula could be modified so that it splits the donation amount based on the number of 'charities' chosen per row? I.e. cells C4 and C10 would become 2500?
And if not, any alternative suggestions would be warmly welcomed.
Many Thanks
May 10 2022 03:05 AM
If it's OK to make the amounts in Sheet1 column D unique, you can use the formula in the attached version. It divides the donation amount by the number of charities that contributed that amount.
Having 2000 occur twice caused problems with that.
May 10 2022 03:44 AM
May 10 2022 03:49 AM
Please provide an example.
May 10 2022 03:55 AM
May 10 2022 04:22 AM - edited May 10 2022 04:23 AM
SolutionYeah, OK, that complicates things (and that's why it's always better to provide a realistic example at the outset instead of adding complexity step by step).
New version attached. I added a helper column to Sheet1.
May 10 2022 04:40 AM
May 10 2022 04:22 AM - edited May 10 2022 04:23 AM
SolutionYeah, OK, that complicates things (and that's why it's always better to provide a realistic example at the outset instead of adding complexity step by step).
New version attached. I added a helper column to Sheet1.