slamanager
Board Regular
- Joined
- Apr 20, 2007
- Messages
- 129
Hi.
I would like a formula to tell me the value in a list that equals 98% of the population of the list.
So I have a pivot table of returns for a month the pivot shows the count of the returns for the unique values in the list.
If there was 10 returns in a list and you got more returns for values 1 2 and 3 probably 98% would be at the 3 value. I can calculate the 98% value on the total volume.
I cannot use goal seek as the unique returns number 1000+
I would like a formula to tell me the value in a list that equals 98% of the population of the list.
So I have a pivot table of returns for a month the pivot shows the count of the returns for the unique values in the list.
If there was 10 returns in a list and you got more returns for values 1 2 and 3 probably 98% would be at the 3 value. I can calculate the 98% value on the total volume.
I cannot use goal seek as the unique returns number 1000+