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

    Moving to Next Highlighted Cell

    Hi Thanks for such a quick reply. I may not have been clear with my request. I would like to highlight a column of TRUE and FALSE statements and move to or go to the first FALSE statement then the next FALSE statement. The reason for this is that when I find a FALSE statement, I need to...
  2. A

    Moving to Next Highlighted Cell

    Hi I have a long column of true/false statements in Excel 2007. I have used conditional formatting to highlight the FALSE statements. Since there are over 4000 lines of data, I would like to know if there is a command to move from one highlighted cell or FALSE statement to the next...
  3. A

    Need to Automate Manual Formula for Adding Rows in Large Excel 2007 File

    Hi I have a large worksheet with revenues/expenses of organizations. Each organization is represented by an identifying number and 5 or 6 rows of data. I need all organizations to be represented by 6 rows even if one row contains 0s. I have been using =COUNTIF(B:B,B2)=6 to screen for those...
  4. A

    Best Way to Compare Two Columns on Different Worksheets Using Excel 2007

    Worked perfectly - Thank you Al
  5. A

    Best Way to Compare Two Columns on Different Worksheets Using Excel 2007

    Hi I would like to compare two columns of data for organizations that are located on different worksheets within the same workbook. Sheet1, Column A contains the 136 target organization numbers. Sheet2 Column A contains the 284 organizational numbers, of the total population and the data...
  6. A

    Problem with Conditional Formatting for Duplicates in Multiple Column Worksheet

    Thank you one and all. Will try suggestions in the morning. Again, thank you. Al
  7. A

    Problem with Conditional Formatting for Duplicates in Multiple Column Worksheet

    Good Morning I have been trying to use conditional formatting (CF) in Excel 2007 worksheet that has 10 columns and 220 lines of numbers. The goal is to identify those numbers that occur in all ten columns. I have tried CF for duplicates and unique values with no success. Is this an...
Back
Top