79585249

Date: 2025-04-21 20:09:30
Score: 3
Natty:
Report link

As of 4/21/2025, Pivot Tables will summarize empty cells. But, the filter function fails to identify a cell using = Empty and = Not Empty (it does not let you use <> Empty). To simply get rid of empty rows, the "Ignore empty rows" works.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: Ron