Hello, I have a formulas in this sheet and everything works fine but it is not picking up on those notification#s that have multiple dates (multiple dates shown as hashtags in the pivot table). If there are multiple dates, I want it to show as "*CHECK*", if that notification is does not exist in column D, then I want it to show as a dash i.e. "-". Can you please help? Thank you.
Excel 2010 with free PowerPivot Add-In.
Compatible with Office 2013 Pro Plus.
Regular PT does not allow text in Values.
http://www.mediafire.com/view/plp0c3.../02_02_15.xlsx
Bookmarks