0
I'm trying to group by date in an Excel 2010 pivot table.
The column with dates (i.e., the one want to group by), should be the latest date of 2 other columns if neither is null, or blank. i.e., with a formula like:
=IF(AND(A4 <> "", B4 <> ""), MAX(A4,B4), "")
Normally, this ""
in the IF()
formula acts the same as an empty cell. In this case, it is preventing me from grouping by date in the Pivot Table. If I filter the date column by (Blanks)
, then clear the contents of all those cells, then the pivot table does group by date ok. i.e., ""
is not being treated the same as an empty cell.