I have trouble running advance filter with true false criteria results. I have a spreadsheet I started years ago showing criteria fields with 1 and 0, and filtering works great.
When I copy this spreadsheet to new blank worksheet, the criteria field shows up as true and false, and the filtering doesn't work. Does anyone know what determines true/false in cells, versus 1 and 0's? This failure to filter on new spreadsheets is driving me up a wall.
Bookmarks