• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    Variance (percentage) between two negative numbers

    Hi, I believe it would be the same formula. Variance = (Actual/Projected)-1 Projected = 10,000, Actual = 5,000 Variance = (10,000/5,000)-1 = -50.00% Projected = -10,000, Actual = -5,000 Variance = (-10,000/-5,000)-1 = -50.00% Brant
  2. B

    Using a between function in a vlookup

    You could use an array formula. In Sheet1("B1"), enter: "=INDEX(Sheet2!$C$1:$C$1000,MATCH(1,(Sheet1!A1>=Sheet2!$A$1:$A$1000)*(Sheet1!A1<=Sheet2!$B$1:$B$1000),0))" (Change 1000 to your last row of data in Sheet2) Enter it as an array formula (CTRL + SHIFT + ENTER), then drag the...
  3. B

    I am facing problem while defining worksheet.

    You're welcome. Same to you!
  4. B

    I am facing problem while defining worksheet.

    Sure thing.. If you remove "macro." from the beginning of the line, your code should run. When you set 'wrk = worksheets("Working")', Excel knows the workbook that the worksheet is in. So, by adding your definied workbook variable to the beginning of 'wrk.range("A1")', you are essentially...
  5. B

    Losing sheet reference in chart series

    Hi All, I've created a dashboard with a chart referencing dynamic named formulas on another sheet for its series values. I'm using excel 2007 (my first problem...), and when I open a copy of the workbook (after it's been emailed to someone for instance), the sheet reference in the chart series...
  6. B

    I am facing problem while defining worksheet.

    Can you post the line that is givin you the error?
  7. B

    I am facing problem while defining worksheet.

    Where is the error happening? At the 'Set wrk = worksheets("Working")' line or later?
Back
Top