- Create a new empty column on the table that has the regular sunspot group number data.
- In the top cell of the new column, enter the formula =(ORIGINAL_COLUMN_ROW - MIN(ORIGINAL_COLUMN)) / (MAX(ORIGINAL_COLUMN) - MIN(ORIGINAL_COLUMN))
- The parenthesis in that formula are very import. Don’t forget them or rearrange them.
- Copy the formula to the rest of the new column.
ORIGINAL_COLUMN stands for the column letter that contains the data you want to normalize, the sunspot group number data. ORIGINAL_COLUMN_ROW stands for the row number in ORIGINAL_COLUMN that’s the same row number you’re entering this formula into on the new empty column.
An example is =(C2 - MIN(C)) / (MAX(C) - MIN(C)).
My apologies for this error.