Use the Minimum value of ColumnA and paste to the ColumnB based on group by

[Aparanjith]

Hi All,

Currently, I have a request where I need to group the data on the ID level and create a new column "Calc_Min_hour" which will take the minimum hour value from the "Min_Hour" column and have that pasted to the new column "Calc_Min_hour".

For Ex:

ID   Min_Hour

1    11

1    11

1    13

2     8

2     9

2    10

2     8

Now based on the above data, the Minimum value of column "Min_Hour" is 11 for ID 1 and 8 for ID 2. So, I need a new column "Calc_Min_Hour", with the data shown below;

Result:

ID   Min_Hour   Calc_Min_Hour

1    11                11

1    11                11

1    13                11

2     8                 8

2     9                 8

2    10                8

2     8                 8

Can some one help me in achieving this?

[mceleavey · Accepted solution]

Hi @Aparanjith ,

This is a simple matter of using the sum tool to find the min value grouped by ID, then joining back.

Hope this helps.

M.

[Qiu]

@Aparanjith 

A bit different approach