If you create a pivot table and drag "Judgement Satisfied" into the rows area and into the values area, you will see that the pivot table starts with a blank cell and then has 17 dates and then has the (blank) row. That shows you that there is a dodgy date somewhere. You could double click the number and the underlying data record will show on a new sheet, but that's quite tedious.
What I did to find the cells with the spaces was this:
- Select from A2 to the end of the data in column M and turn the data into a table (Insert > Table)
- create a new column with the formula =len(h3), which will be copied down. This shows the character count for each cell.
- use the filter drop-downs to check if there are any cells with a funny character count. A date will return 5 (because it is a number with 5 digits, formatted to show as a date). Empty cells show a 0 count. Anything other than that is possibly a wrong entry.
Bookmarks