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), "")
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.