for an add in that does. (Don't know if there is one, but it would be where I'd go...)
Paddy
P.S. If, as Tushar suggested, you search Google & come up with anything more specific than the trapezoid rule, let me know 'cos I'vw searched there before on this topic without much luck.
The google post is from me and is a first attempt to do symbolic mathematics in Excel. Alexander Chachin uses Gaussian quadrature, so his posts are a nice improvement. Nico Sterk took my stuff, amended it a bit and put it on his web page (Check his site for other pretty cool things).
With just data points, as you have, the above won't work too well, so I'd go with Tushar's link.
If you want some options, here is a nice thread...
Excellent references. I don't know how I forgot about the discussion you'd initiated. Well, actually, I do. The saved articles were lost in a newsreader corruption of the .programming NG
I also liked Eero Tibar's use of defined names. After reading his post, it was like, "Duh! That's so obvious" But, in hindsight everything is! <g>
And, yes, Dave Braden's cubic spline code remains a 'must have!'
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.