Dear all
I have already posted this problem an linkedin Blackbelts group & its still under discussion, Thought this forum could have another perspective of this.
PROBLEM:I need to extract department names in descending order using the INDEX,LARGE,MATCH formula combo based on cost values
For a group of departments with similar cost i.e. without unique values only the first department name is extracted. The subsequent department names are not extracted as their cost value are not unique. Please kindly advise the best formula solution for this management reporting problem.
I have already posted this problem an linkedin Blackbelts group & its still under discussion, Thought this forum could have another perspective of this.
PROBLEM:I need to extract department names in descending order using the INDEX,LARGE,MATCH formula combo based on cost values
For a group of departments with similar cost i.e. without unique values only the first department name is extracted. The subsequent department names are not extracted as their cost value are not unique. Please kindly advise the best formula solution for this management reporting problem.
