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 Functions and Formulas forum. See all tags in the site
  • Re: excel challenge issued by my boss (help)

    To simplyfie bentleybob's suggestion you can have a look at this add-in: http://www.mrexcel.com/chal/pareto.zip All of the formulas in B are =RAND() functions. Click the checkbox to recalc, and a whole series of dynamic range names cause the chart to redisplay sorted values. It also make it possible...
    Posted to Functions and Formulas (Forum) by wendel on Mon, Aug 24 2009
  • analysing charts with formulas

    Dear forum users, I am working on a tool which graphically shows the stock coverage in weeks for all products we have, per product. We have pre-defined max coverage and min coverage. On this picture you can see in red the max, in blue the min and in green the actual (projected) coverage. http://docs...
    Posted to Functions and Formulas (Forum) by laguerriere on Sat, Mar 14 2009
Page 1 of 1 (2 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.