Hi forum,
I have created a max+if and Min+if array that looks for the max and min paying prices per each product/customer transaction (see attache excel).
However, my data base is not "clean". It contains lot of small values that distort the result.
The way to go over this problem is by looking only on the top customers (top 75% in terms of qnt).
I have created pivot and OFFSET table to do that, but I am sure there is a simple easy way to do what I want to do
What I am basically trying to do is to create max+if within a limited range.
Would appreciate your support.
regards
SwissExcel
Bookmarks