So I have a column of data that was logged by this instrument cumulatively. For example the column goes: 3, 7, 8, 19. The problem is I need to graph that from moment to moment so I need that changed into: 3, 4, 1, 11. Any suggestions?
So I have a column of data that was logged by this instrument cumulatively. For example the column goes: 3, 7, 8, 19. The problem is I need to graph that from moment to moment so I need that changed into: 3, 4, 1, 11. Any suggestions?
Last edited by zax11029; 07-14-2010 at 11:15 AM.
You would need to put this calculation into the next column (assuming your data starts in A2). Starting in B3
=IF(ISNUMBER(A3), A3-A2,"")
Dragged down.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes that worked perfectly! Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks