Results 1 to 2 of 2

Thread: Formula not picking up multiple dates

  1. #1

    Formula not picking up multiple dates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •