Hi All,
I will try to explain my question as good as possible.
I have a pivottable from a data dump.
This pivottable shows 2 columns
- first is percentages
- second is the number / count of those same percentages.
So in my attached excel you will find an example.
I am using a countif and a countifs formula to count the number of percentages
in a certain range.
<85%
> 85% - < 120%
>120%
The problem I have is that some percentages are the same as you will see in the excel.
My formula works :
=AANTALLEN.ALS(A2:A8;">85%";A2:A8;"<120%") (Dutch version but I think you will automatically have the English formula when opening in your language right?)
However I need a count if the % appears more than 1.
Please see my excel with what I mean
My pivottable shows:
% Number of times
78,50% 1
45% 1
123% 2
90% 1
34% 1
98% 1
140% 1
Because I have my formula count in the first column I am having "gaps" for
I actually need a formula that says look at the percentage and then if condition is met,
take value from column 2
How can I arrange that?
Once again if you look at my excel file attached you will see what I mean.
I really hope I have explained it well?
I really would love to have the answer to this one.
Thanks!
Marco
Bookmarks