soderlloyd
New Member
Hello everyone 
Thank you for your help.
I am trying to calculate an "adjusted" value (column E) based on two other columns (C & D) (sample data attached  the full data has 200+ rows).
If column C = "Total", column E = column D. Easy. However, if column C = "8350019" or "8350000" then a calculation has to be done with data from 2 rows corresponding to the same person (highlighted).
Thank you again and I'm happy to explain more if needed!
Laurel
Thank you for your help.
I am trying to calculate an "adjusted" value (column E) based on two other columns (C & D) (sample data attached  the full data has 200+ rows).
If column C = "Total", column E = column D. Easy. However, if column C = "8350019" or "8350000" then a calculation has to be done with data from 2 rows corresponding to the same person (highlighted).
Thank you again and I'm happy to explain more if needed!
Laurel
Attachments

9.2 KB Views: 3