Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.