I have 4 spreadsheets, each with a "Group" (A) column, "Name" (B) column, and "Path" (C) column. Values were compared on "Name" across the 4 sheets and differences were counted and recorded in a table. Therefore, each sheet contains 3 different tests indicating differences against the 3 other sheets (sheet 1 to 2, 2 to 1, 2 to 3, 3 to 2, etc.). However, I want to create a drilldown in Excel where a user can click a number in the table and differences will be shown on a more granular level, divided by group. Is there an expand tool where this information can be entered manually an expanded/contracted by the user, or is a pivot table the best method? If so, how would I go about creating it?
Thank you, and let me know of any questions.
Bookmarks