Pareto principle & formula array

[szynszyl]

Hi,
based on a long list of p/n and relevant value in US$ (in descending order) I would like to find lonely the few items which sum rappresent 80% of total value.
Do you know if it's possible with formula array??

Thanks

Marco

 

[SkipVought]

Hi,

No need for VBA.

Apply the AutoFilter.

Select Custom... in the filter in the US$ column. Then select the PERCENT you want to make visible.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]