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

Recent content by GODZILLA

  1. G

    Price Brackets for retail scan data...

    IF(AND(A1>0,A1<=5),"$0-5",IF(AND(A1>5,A1<=8),"$5-8,0)) etc
  2. G

    Creating a PDF from EX07 with a workbook featuring a photo of a graph error

    http://cid-0f6e09a4620efc19.skydrive.live.com/redir.aspx?resid=F6E09A4620EFC19!132
  3. G

    Creating a PDF from EX07 with a workbook featuring a photo of a graph error

    Hello, My problem is one i have been trying to over come for a while now. I have a few dashboards that have images of graphs that are taken using the camera tool. This is because they need to be rotated etc. When i print the report to PDF using the in built Save As PDF the images of...
  4. G

    Excel Histograms with var bar widths

    Hello, Does anyone have any experience with histograms with different widths? Similar to the graph in this image: http://www.gcsemathstutor.com/images/information/info-histogram.jpg Thanks Terry
  5. G

    Function to change 1 to A 2 to B 27 to AA etc

    Cracking! Thanks
  6. G

    Function to change 1 to A 2 to B 27 to AA etc

    Hello, I have a match formula bringing me back the reference of the cell i need however i need this in AZ etc. Is there a function that can do this? Thnaks
  7. G

    dragging formulas so they refer to correct cells

    Hello, Error statements: 2003 =IF(ISERROR(STATEMENT),"ERROR MESSAGE",STATEMENT) 2007 =IFERROR(STATEMENT,"ERROR MESSAGE") The $$$ are limiting your average to c2:c13. Thanks
  8. G

    comparing 2 lists of names

    Hello, Im sure i saw a post before where chandoo had 2 lists of names and he made a list new list of unique names only in a third list. i.e. List 1: Cat dog mouse bat list 2: cat bat flag hammer list 3: Cat dog mouse bat flag hammer How is this done? Thanks
  9. G

    Change the criteria of multiple Pivot tables at once

    Hello, Is it possible to change the criteria of a bunch of pivots at once? What i want to do is i have month as a criteria (in number 1,2,3...) I want to change all to look at a different month at once. I know i could use VBA...
  10. G

    Lookup with reference to 2 columns

    Use index and match. =Index(Value,match(Sheet1.Location & Sheet1.Material,Sheet2.Location & Sheet2.Material,0)) then hold Ctrl Shift and enter. Replace Sheet1.Location etc with the cell you want to look up. What this does is index the column that contains the data by finding the...
See more
Back
Top