Hello,
PFA excel file. Looking for a single cell formula (possible an array formula) whereby I could determine highest and single sales value, to guage sales performance by region, salesperson and product. The problem is already solved by a Pivot table, but I want it to be dynamic in the event of change in the variables.
PFA excel file. Looking for a single cell formula (possible an array formula) whereby I could determine highest and single sales value, to guage sales performance by region, salesperson and product. The problem is already solved by a Pivot table, but I want it to be dynamic in the event of change in the variables.