Results 1 to 2 of 2

Thread: Summarize Data using Formula or Pivot Table

  1. #1

    Summarize Data using Formula or Pivot Table

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

    Attached are Fields from 14 applications my firm uses between our 5 offices. What I am trying to do is figure out how many offices and reports use a field. So for example, "Comments" (rows 41 - 44) is used in 2 states and 4 application. I am not looking for the COUNT, i am looking for the actual state abbreviations and report name. Thus for "Comments", the result should show: Comments is used in CA & NY and in Report D, Report E, Report J, Report L, Report N.
    Attached Files Attached Files

  2. #2
    Seeker jpr73's Avatar
    Join Date
    Apr 2011
    May be a solution using pivot table
    Note that the field name in PT is unique : see attached
    You can also filter your data in Sheet 1 but the fields are not summarize
    Hope this helps
    Best regards
    Attached Files Attached Files

Posting Permissions

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