Find Min and Max from multiple columns ( Same name of colums)

[#1]

Hello,

I have huge data in excel and it has multiple columes with same name ( this is format i get from tester). And i would like to calculate min, max, stdev and mean from all columes. 

I tried to open data in JMP but JMP remanes the colume name to ( Av, Av1, Av2, Av3.......) and then if i use tabulate it shows min, max for Av, Av1, Av2.... etc., but i wanted min and max for all ( Av, Av1, Av3, ...). 

Pls help. Attached raw data for. 

[#2]

Pls help to add Word(1, :Label, " ") in above script. 

[#3 · Accepted solution]

All of what I am going to show you below is covered in the Using JMP book

     Help==>Books==>Using JMP

What needs to be done is to create a new column in your data table, and apply a formula to the column. 

1. Open the stacked data table and click on the red triangle in the column area above the row state column.  Select "New Column"

 

2. The Column Info window will open.  Change the name of the new column to whatever you want(I chose "Label 2").  Also change the Modeling Type to "Character"

3. Click on OK and then Right Click on the header area of the new column and select "Formula"

4. In the formula editor, double click on the box titled "No Formula"

5. Rather than doing the point and click formula building that we could do, with this simple formula, we just need to type it into the box

6. Once the typing is done, just click on OK or Apply and the formula will generate the new values

You can now use this new column in your Tabulate Platform