Sum the first Instance of a duplicate across two criteria. Example attached.
I would like to get a sum of invoices against each Business unit per Account. Unfortunately there are duplicate data in this raw export.
Before I have a crack at the guy who produced this, Can you please let me know if there is a way of just summing the first Instance of the no. of invoices per account per business unit?
Thanks in advance.
SPR_EX.xls
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks oeldere.
I also want to sum the first Instance of the no. of invoices per account per business unit in a style same as the one shown on the Summary - PPT Tab. I've already done one, but it is just a count of the number of occurrences of Individual bus units on the Data Tab. Currently in that export, if there are 5 invoices against an account for a bus init, there are 5 lines. So my approach works. It will fail where there are unequal number of occurrences of bus units to the no. of invoices released.
Hope that makes sense.
Nope (not for me), but maybe the desired (expected) result in your sheet will.
if i understood your requirement correctly, this might be of help (see highlighted regions):
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Thanks icestationzbra. Exactly what I had in mind. Now to decipher the Formulae
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks