• 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. A

    Lookup across a broken range

    Hey, cool. Thanks a tonne. Also thanks for putting the spreadsheet somewhere more useful than google docs. I should have done that from the start. All three of your fomulas are prettier than mine. A side question though: Is it best to avoid using arrays, like I did on the top table, because...
  2. A

    Plotting large sales ranges on bar graph

    This problem annoys me. The best work around that I've found is to make two graphs, same size, same data. Put them above one another and remove the x-axis labels from the top one. Then specify the values of the y axises so that one is small numbers (say, 1-5) and then the other is high...
  3. A

    Lookup across a broken range

    Hey there, Thanks for trying. For some reason Goole Docs is not as easy to use as I thought. I'l upload the sample to Rapidshare at work on monday. But in the mean time I have added you as a collaborator, and (I think) made the doc totally public. So try again and let me know how you go...
  4. A

    Lookup across a broken range

    Hi there, After presenting the most rediculously detailed financial model of a factory to my boss, he complained that I used arrays and If functions where I should have used the LOOK Up Function. So now I need to change the function that a cell uses, the problem is I dont know how. I've...
Back
Top