Return the Row Number of Maximum

Hegedus

Hi,

 

Is it possible to get the row number of the maximum value of a column?

 

I would like to create a formula that uses a value in a column as an offset and I would like to write it in generic form such that it looks in Col1 for a maximum value and then returns the row number such I can use the value of col2 at that row number as the offset.

 

How could I do this?

 

Thanks in advance

 

Andy

txnelson

Here is a simple solution to your issue.  It can be moved directly into a formula, or used in open code as it is shown:

names default to here(1);
dt=open("$SAMPLE_DATA\Semiconductor Capability.jmp" );

MaxRow=(dt<<get rows where(Col Maximum(:NPN1)==:NPN1))[1];
show(MaxRow);