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...
Hello Guys
Need to show only 5 top records dynamically, under specific area/name using an array formula. I extracted the names but it is not showing under specific area, it started from top to bottom order.