Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
Regular business hours will resume on Monday, October 5, 2026.

JMP Knowledge Base

Is there a way to rank a column in my data table in JMP®?

Created: Nov 30, 2022 04:34 PM | Last Modified: Feb 5, 2023 2:06 AM

Yes. Select Analyze ► Distribution. When the results window appears, click on the inverted red triangle menu next to the column name and select Save ► Ranks or Ranks Averaged.

Alternatively, select the column of interest, right click on the column ► New Formula Column ► Distributional ► Rank. This will generate a new formula column with the Rank by row of the observations in the column of interest.

[Previously JMP Note 35352]

JMP Knowledge Base

Recommended Articles