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

    Formula create border to separate categories based on values + add text [SOLVED]

    This works perfectly! Thank you sooooooooooo much!
  2. J

    Formula create border to separate categories based on values + add text [SOLVED]

    This is fantastic! Is there any way to have these either: Merge with the cell below so they are centered with the line. OR I would be happy with AVG= being in one cell and 77 being in the cell below so they line up. Thank you so much, I was trying to go about this is a very backwards way!
  3. J

    Formula create border to separate categories based on values + add text [SOLVED]

    Thank you - the lines are now drawing via conditional formatting. I will now try to see if I can add the text. Thanks for your help!
  4. J

    Formula create border to separate categories based on values + add text [SOLVED]

    Thank you!! You are right, the average does not equal the total column,it needs to relate to the cell w/ the total.
  5. J

    Formula create border to separate categories based on values + add text [SOLVED]

    FYI, this post contains my original query http://chandoo.org/forums/topic/how-to-merge-cells-and-insert-data-based-on-change-in-data-in-adjacent-column
  6. J

    Formula create border to separate categories based on values + add text [SOLVED]

    Hi! I posted last night about how to use conditional formatting + formulas to add text (thank you Hui). However, I have run into some tables that have 3 categories of information and I can't figure out how to accomplish what I need to...
  7. J

    merge cells and insert data based on change in data in adjacent column [SOLVED]

    This is perfect, thank you SO much!!
  8. J

    merge cells and insert data based on change in data in adjacent column [SOLVED]

    Hi! I am working on project for a company that owns a bunch of other companies. Every month, they populate an excel file w/ about 50 tables with data from hyperion. They then manually sort each of these tables, and in order to compare how each company is doing against the average - they draw a...
Back
Top