Forum Discussion
How to count the total value of unique items
Hi
We want to be able to measure the total value of unique approved... So basically filter out anything that is approved...
Could you:
- Clarify the above point
- Post of picture (better share a sample representative workbook) showing your data + the expected result
- What version of Excel do you run + on which platform (Windows, Mac, Web...)?
I thought I answered this, but my answers might not be posting.
I am including a screenshot below of basically what my data looks like. A project comes to us for approval at 3 different levels. Each time, we approve, or send it back for feedback. A project could come to us multiple times within a level, (and this can happen even if they were approved the first time). A project also should come to us at each level for approval.
What I am trying to provide to leadership is a view of the value of the projects that are moving through this process. However as I'm sure you can understand, if we count an initiative multiple times, those values will be significantly inflated. So I have been going through manually to remove duplications before doing the weekly totals.