Looking to find a formula to see how many Sources there are per Product that match under a certain division and Deal ID. this would need to be its own column per row
See attached and let me know if you need more information.
Thank you!
Looking to find a formula to see how many Sources there are per Product that match under a certain division and Deal ID. this would need to be its own column per row
See attached and let me know if you need more information.
Thank you!
with a pivot table.
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.
How about updating the file to show us what results you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I would like to see how many sources a product has per division per deal. The criteria would be division + deal id + product. I'm guessing each column would be an array?
Thank you! However, I'm looking for a formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks