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

    Auto Formatting Problem with Formula and #DIV/0! error in calculating Percentage

    Column A Column B 10 0.2 (=A1/A5) 14 #DIV/O! (Auto formatting or drag drop gives this) 6 20 50 (THE SUM) I have lot of data like this. Can't put formula in every cell.Please give a solution if i want that Sum to be their in the last Row.
  2. W

    Auto Formatting Problem with Formula and #DIV/0! error in calculating Percentage

    ROW A filled with numbers Sum of ROW A is the last number. In ROW C i want to calculate the value of ROW A divide by Sum of ROW A, that is the last number. Individually by putting formula it works but not filling automatically and gives error #DIV/0! Can someone suggest how to solve, need...
  3. W

    Conditional Formatting-Excel School

    Hi, In your excel school demo you have shown how to compare values in two rows and format them. How will you do if you have more then 3 rows. Eg. 4 rows, i want d row to be colored if c1<=d1<=a1
  4. W

    how to freeze text box

    suppose there is a long sheet, in which on the right side i have placed a text box with a message on it. when we scroll down that text box disappears, how to freeze that text box or image when scrolling down?
  5. W

    shortcut to insert rows

    what is the shortcut to insert rows and columns into an excel sheet
Back
Top