Hello - Long time lurker, second time poster.
I am trying to see if I can limit an array range when LARGE asks for the array based on a header and column categories; returning Vendor Name / Feb Amount / Δ% for the highest Δ% in category selected by drop-down.
I've attached testing file. Options I've considered -
- Do I need to make source data a Table?
- Is there a better way to arrange source data to make formula's easier?
Any help would be appreciated.