Taking data from regularly updated table

**eveza** · 02-15-2019, 08:32 PM

Hello,

I would like to create a spreadsheet where I paste a small table of information, like this:

Andrew	55
Bob	64
Chris	71

on a regular basis (say once an hour). The spreadsheet would take the number associated with the name and work out the difference from the previous hour. I would like to do this every hour. Ideally, it would also be able to work out an average change over say 12 hours.

I can't find a way of doing this automatically. Is it possible in Excel, and if so, how?

Thank you.

**kvsrinivasamurthy** · 02-16-2019, 01:58 AM

Pl attach a small sample file showing before and after with results.

**GeoffW283** · 02-16-2019, 08:31 PM

First of all - welcome to the forum!

Are you looking for something like the following?

updatedTable.png

Difference from previous entry: In C5 then copied down:

Formula:

Please Login or Register  to view this content.

Average of previous 12 results: In D2 copied down:

Formula:

Please Login or Register  to view this content.

This formula averages as many prior results as are available up to a maximum of 12.

Anywhere close to what you want? If not then please do as requested in post #2.