**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.*