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

    Focus No Longer Moves to Beginning of Next Row when pressing Enter

    I used to be able to enter data in a row in an Excel spreadsheet by tabbing across cells, then when I was finished and hit enter the focus would move to the first cell in the next row (or the cell in the next row underneath the one where I first started tabbing across). So: Start in A1, tab...
  2. O

    Conditional Formatting Adds Itself When I tab to the Next Cell

    I have a spreadsheet that has conditional formatting on 2 adjacent cells (G5 & H5). The formatting uses a formula to highlight the cells if the sum of their values is higher than the value in a third cell (D5). The conditional formatting works fine. However, having entered values into each of...
  3. O

    Should I use Array Match/Index for my Application?

    Hello good folks, I am thinking about creating a spreadsheet to keep track of items (lets call them recipes) by keywords (lets call them key ingredients). Before I actually start to type in huge wodges of data I need to ensure I understand how to format it. So what I thought was: Data Sheet...
  4. O

    How Do You Group Dates when Using Distinct Count in a Pivot Table?

    I have been waiting for my organisation to upgrade to Excel 2013 so I could use Distinct Count in a pivot table I created some time back. I was shattered to find that I lost the ability to group dates. In the attached file, I wish to have a pivot table that shows me the number of meetings held...
  5. O

    Enter Key doesn't go to new row when spreadsheet is protected

    I have a sheet that is protected, with some columns enabled for data entry. Normally when you enter data into a sheet, pressing TAB to go from column to column, when you press Enter you go to the first column (or the column you started in) in the next row. However, with my protected sheet...
  6. O

    Month Name Always Shows as January

    I am in Australia so have my dates formatted as dd/mm/yyyy. I wish to show the month name for a date, so I can set up a pivot table for the data. I use the =Month() formula to obtain the month number, then format the cell with mmmm to show the name, however no matter what my date the month...
Back
Top