Pls someone assist with formula to distribute revenues across yearly col. - see attached file. Very much appreciated!
RevenueAllocation.xlsx
Pls someone assist with formula to distribute revenues across yearly col. - see attached file. Very much appreciated!
RevenueAllocation.xlsx
What does your expected output look like?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
In G3
=(IF(AND($B3<G$2,$C3>G$2+1),MIN(G$2-$B3,G$2-EOMONTH(G$2,-12)),IF($C3<G$2,MAX(0,($C3-EOMONTH(F$2,0)+1)),0)))*$F3
in F3
=D3/(C3-B3+1)
John,
You are an Angel!
A million thanks!
You're welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks