Compare content of columns in two workbooks - output/visual as a dropdown list to show matching %'s

seville90

New Member
Joined
Jan 17, 2023
Messages
1
Office Version
  1. 2016
In Spreadsheet 1 I have the following:

Column A - Filename
Column B - Folder name
Column D - Parent folder name

In Spreadsheet 2 I also have the following:

Column A - Filename
Column B - Folder name
Column D - Parent folder name

I need to compare a 'before' (Spreadsheet 1) and an 'after' (Spreadsheet 2).

I need to be able to group by Folder name and Parent folder name and see the matching % when doing so.
e.g. Folder "Folder 1" on Spreadsheet 1 has 1000 files associated to it. However on Spreadsheet 2 it has 900 files associated to it.
Therefore when selecting Folder 1 from a dropdown list of folders, it shows matching as 90%.

I'd also like to be able to select the Parent folder names from a dropdown which calculate/show the total matching % of files across all child folders.

How would I achieve something like this? I'd like a user friendly front page with a dropdown essentially where users can first select the parent folder and secondly (optional) select the child folder to see the matching %'s.

Thanks

Very basic visual of the columns below. But the actual spreadsheets have over 400,000 rows.

Book1
ABCD
1FilenameFolder NamexxxParent Folder name
2File 1Folder 1Parent 1
3File 2Folder 1Parent 1
4File 3Folder 1Parent 1
5File 4Folder 2Parent 1
6File 5Folder 3Parent 1
7File 6Folder 3Parent 1
8File 7Folder 4Parent 1
9File 8Folder 5Parent 1
10File 9Folder 5Parent 1
11File 10Folder 5Parent 1
12File 11Folder 5Parent 2
13File 12Folder 6Parent 2
14File 13Folder 6Parent 2
15File 14Folder 7Parent 2
16File 15Folder 8Parent 2
17File 16Folder 8Parent 2
18File 17Folder 8Parent 2
19File 18Folder 9Parent 2
20File 19Folder 9Parent 2
21File 20Folder 10Parent 2
Sheet1
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top