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

  1. dolphintabby

    Conditional highlight an occurance of partial text

    I have a large table of data and I want conditional formatting to highlight an item if it contains a specific part of a text. For example part number is Z10105 but there are 1,000 of parts that begin with that series Z10105MJB, Z10105QZR,...etc, etc and I want a flag of highlighting it if it...
  2. dolphintabby

    =SavedDate()

    Thank you. You were right. :)
  3. dolphintabby

    =SavedDate()

    I got this formula somewhere and it works fine on 1 file. I just tried to add it to another file and it returns #NAME? error. Now I can't find anything on this formula. Regards, ~Dee
  4. dolphintabby

    If statement that looks at the results of formula

    I am trying to write an If statement that looks at a cell that has a calculated formula in it but if the answer is 0 for it to return a blank but if it is not 0 I want it to compare the results with the calculation in another cell on another worksheet (Cell=calculated average cycle time) and...
  5. dolphintabby

    Pivot table count results of formula

    I tried to figure out how you added month and year to the pivot fields but I haven't been able to figure it out. How did you separate them out?
  6. dolphintabby

    Pivot table count results of formula

    Wow you are awesome! Thank you :)
  7. dolphintabby

    Pivot table count results of formula

    That is awesome but I also needed it divided across the top where it says FMQR by month I also need it by Type so horizontal access is by type and vertical like you have it by month. :)
  8. dolphintabby

    Pivot table count results of formula

    See attached. :)
  9. dolphintabby

    Pivot table count results of formula

    Okay it let me this time see attached
  10. dolphintabby

    Pivot table count results of formula

    How can I get the pivot table to count the number of the results of a formula instead of counting the number of formulas in a column of cells? When I created a pivot table it gives me a total count of cells that contain a formula instead of the total number from the formula which is a text. The...
  11. dolphintabby

    Formula execution on a true if statement

    I am trying to have a cell look at another cell with a date in them (i.e. 12/15/2011) and return only the 3 letter Month but only if there is a date in the cell. I tried the below formula which doesn't work: =IF(C5>1,=TEXT(DATE(YEAR(C5), MONTH(C5), DAY(C5))," MMM")," ") If I just do the...
  12. dolphintabby

    Running average results of formula

    Oh okay thank you :)
  13. dolphintabby

    Running average results of formula

    Thank you that worked :)
  14. dolphintabby

    Running average results of formula

    How can I get the average of the results of a formula and have it update with every entry? I have a column that calculates the cycle days between when I receive a report request and when I complete it. The formula is =NETWORKDAYS(M29,O29,) I want to calculate on a summary page what my average...
  15. dolphintabby

    Sum if with index match

    @ Luke M I know it has been a year and I am not sure what happened with my project lol but how do I pull data from several sheets into a single pivot table? ~Dee
See more
Back
Top