Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Re: scientific calulations using scattter and trendlines

    Hi Steve, Rather than use VBA, I've developed a worksheet only solution, using dynamic named ranges, LINEST linear regression function, datatables, index/match to pick out the best results, and finally solving the simultaneous equations and plotting!! Sorry I don't have time to explain the whole...
    Posted to VBA (Forum) by Rick Williams on Wed, Jan 13 2010
Page 1 of 1 (1 items)
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.