Jump to content
We've recently updated our Privacy Statement, available here. ×

Copy values depending on column


Recommended Posts

Hello,

I have something like this, and I'd like to get what is in the NEW_COLUMN, which is the substraction of the last trial - the first one per Name:

 

 

 

Trial

Name

Value

NEW_COLUMN

 

 

1

Paul

200

 

 

 

1

Mario

100

 

 

 

1

Louisa

59

 

 

 

2

Paul

150

50

 

 

2

Mario

99

1

 

 

2

Louisa

55

4

 

 

 

I've tried doing it with over, but it has been impossible so far.

 

Thanks,

Juan Pablo.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...