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

    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
  6. 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
  7. 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
  8. 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...
  9. 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...
  10. G

    2 quick how do I questions

    Exactly what I wanted! Thanks
  11. G

    2 quick how do I questions

    Hello, Happy New Year! How do I limit the amount cells a user can see? How do I create a little drop box next to a cell to allow the user to select the cells value with out using a drop down box. Thanks Terry
  12. G

    Count if using indexing and matching

    Thanks works a treat. Countifs? Is that a new feature to 07?
  13. G

    Count if using indexing and matching

    Hello, What i am looking to do is count the amount of records that meet more than one criteria. For instance i ahve a column with names in and a column of outcomes. I want to count when the names column (A) = "GODZILLA" and Outcomes (B) = "Started". How can i do this? Thanks
  14. G

    Code for UserForm

    Have you looked at a database for this sort of thing rather than Excel? You could do it in Access fairly easily (with a form and a recorset) and link the data back in to Excel for reporting. I would try to keep away from using Excel as a database (which imo it sounds like you're doing)
  15. G

    Data filters using a dropdown menu.

    Right what i have done is use the crieria for an auto filter as a var and work it that way. This does work however i would love a way that does not use VBA. Any ideas? Thanks
  16. G

    Data filters using a dropdown menu.

    Hello, I have a large table of data in Excel. What i have currently is a summary table using indexing and matching which shows performance of whoever is selected in a dropdown menu. What i want is whoever is selected on the main sheet filter and only show me everything associated to...
  17. G

    Incell charts

    Thanks guys i will have a look through. Thanks again.
  18. G

    An interesting question....

    Hello, I think i have an interesting question. Can you use a formula to change the size of text? I have a list of names and ranks. I want the higher ranked names to be larger. Any idea?
  19. G

    Incell charts

    That doesnt seem to change much. If I use Webdings rept("g",A1) it works better but the size of the blocks is too large. My intention is to create a solid bar btw. Can you recomend a different option? Thanks
  20. G

    Incell charts

    Hello, I have a series of incel charts working of the REPT("|", A1) A1 having a %*10 to make a chart. I need a performance indicator. I tryed adding a line where 100% was over the incell bars. However when you print preview the Incell look different in Print preview then in the dashboard...
Back
Top