Summarize Data using Formula or Pivot Table

PraveshG81

New member
Joined
Oct 6, 2011
Messages
22
Reaction score
0
Points
0
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.
 

Attachments

  • Excel.xlsx
    26.6 KB · Views: 39
Hi,
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
 

Attachments

  • Summarize Data PT_jpr73.xlsx
    34.7 KB · Views: 33
Back
Top