Question description:
This user has given permission to use the problem statement for this
blog.
I have share prices of several companies in a column for 10 years. I need to calculate the difference in share price each year. Can you help me how can I put a formula that calculates difference at every 10th item?
Solved by E. Y. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/09/2018 - 09:30
Welcome to got it pro.
We are delighted to have you here with us.
User
09/09/2018 - 09:30
Hi
Excelchat Expert
09/09/2018 - 09:30
I believe I can help you with the problem.
Excelchat Expert
09/09/2018 - 09:31
Before we start, would you please show me some sample data?
User
09/09/2018 - 09:31
sure
Excelchat Expert
09/09/2018 - 09:31
Thank you.
Excelchat Expert
09/09/2018 - 09:31
I'm waiting for the data.
User
09/09/2018 - 09:33
[Uploaded an Excel file]
User
09/09/2018 - 09:33
got it?
Excelchat Expert
09/09/2018 - 09:33
Yeah, thank you.
User
09/09/2018 - 09:34
i have share prices of several companies for 10 years
Excelchat Expert
09/09/2018 - 09:34
It is column D, right?
User
09/09/2018 - 09:34
i need to calculate the difference in the share price for each company
User
09/09/2018 - 09:35
yeah. its D
User
09/09/2018 - 09:35
In E column i need difference
Excelchat Expert
09/09/2018 - 09:35
Okay.
Excelchat Expert
09/09/2018 - 09:35
Is there anything else?
User
09/09/2018 - 09:35
but with an interval of 10 years
User
09/09/2018 - 09:35
Nothing more
User
09/09/2018 - 09:35
please if you can help me out
Excelchat Expert
09/09/2018 - 09:36
I believe I can help.
User
09/09/2018 - 09:36
your kind
Excelchat Expert
09/09/2018 - 09:36
If you were to do it manually, what should be the result? Can you show me 2/3 examples?
User
09/09/2018 - 09:36
Ok
Excelchat Expert
09/09/2018 - 09:37
Thank you. Please carry on..
User
09/09/2018 - 09:38
[Uploaded an Excel file]
User
09/09/2018 - 09:38
please see column E
Excelchat Expert
09/09/2018 - 09:39
I'm looking at it.
Excelchat Expert
09/09/2018 - 09:40
It looks like you have just subtracted two years prices.
User
09/09/2018 - 09:40
yeah
User
09/09/2018 - 09:40
but upto 2017
User
09/09/2018 - 09:41
again I have to do it for the other company from 2008
Excelchat Expert
09/09/2018 - 09:41
Oh I got it now.
User
09/09/2018 - 09:41
are you getting me?
Excelchat Expert
09/09/2018 - 09:41
Yeah.
User
09/09/2018 - 09:41
Great
User
09/09/2018 - 09:41
Can we sort it out?
Excelchat Expert
09/09/2018 - 09:42
The subtraction is based on Column B company names, right?
User
09/09/2018 - 09:42
yes
Excelchat Expert
09/09/2018 - 09:42
Yeah, definitely. Although I need some time.
Excelchat Expert
09/09/2018 - 09:42
Please stay with me..
User
09/09/2018 - 09:42
okay
Excelchat Expert
09/09/2018 - 09:46
Please use this formula in column E =IF(MOD(ROW()-2,10)=0,D2,D2-D1)
User
09/09/2018 - 09:46
OK
User
09/09/2018 - 09:46
THx
Excelchat Expert
09/09/2018 - 09:46
[Uploaded an Excel file]
Excelchat Expert
09/09/2018 - 09:47
Here is the file with formula applied.
Excelchat Expert
09/09/2018 - 09:47
Please let me know if need any clarification.
User
09/09/2018 - 09:48
Thnk u very much for your help
Excelchat Expert
09/09/2018 - 09:48
I'm really glad to be able to help.
User
09/09/2018 - 09:48
God bless u
Excelchat Expert
09/09/2018 - 09:49
Please do rate my service. A 5 star tating would be much appreciate.
User
09/09/2018 - 09:49
OK
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.