Help with Ranking Multiple Expressions

[#1]

Hi,

I need help with ranking multiple expressions in a pivot
table with on dimension.  Currently my
table looks like below:

What I need is the focus area for each row where development
= “Yes” to give me the header for the lowest score in Column range 2 to 6. Is
this possible?

Regards

RL

[#2]

I am trying to use some thing like:

if(Column(7)='Yes', If

(Column(2)<Column(3) and Column(2)< Column(4) and Column(2)< Column(5),vRank1,1))

vRank1 = 'Add Product'

However it falls appart because of the '-'. Any suggestions please?

Regards R

[Gysbert_Wassenaar · Accepted solution]

Try using the rangemin function:

If( Column(7)='Yes',

     if( rangemin(Column(2), Column(3),..etc ) = Column2, '% tNPS (overall)',

     if( rangemin(Column(2), Column(3),..etc ) = Column3, 'Add Product',

     ...etc

     if( rangemin(Column(2), Column(3),..etc ) = Column6, 'NUC') ))))))

And make sure all the parentheses match up

[#4]

Thank you Gysbert, it worked with a slight tweek

Used the following to counter the '-':

IF

(Column(7)='Yes',

if

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(2)),vRank1,

if

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(3)),vRank2,

if

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(4)),vRank3,

if

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(5)),vRank4,

if

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(6)),vRank5))))))

Regards Rahul