M
Maciej Grzywna
Hi,
is there a way to calculate max value within one company and repeat it in
every row of that company? In other words I have this:
Company number, Var1
12, 6
12, 4
12, -3
34, 2
34, 4
56, -5
78, -4
78, -12
and would like to get this:
Company number,Var1, Var2
12, 6, 6
12, 4, 6
12, -3, 6
34, 2, 4
34, 4, 4
56, -5, -5
78, -4, -4
78, -12, -4
thanks
Maciek
is there a way to calculate max value within one company and repeat it in
every row of that company? In other words I have this:
Company number, Var1
12, 6
12, 4
12, -3
34, 2
34, 4
56, -5
78, -4
78, -12
and would like to get this:
Company number,Var1, Var2
12, 6, 6
12, 4, 6
12, -3, 6
34, 2, 4
34, 4, 4
56, -5, -5
78, -4, -4
78, -12, -4
thanks
Maciek