Similarity of Lists to each other as %

[calebd]

I've got a number of revisions of an item with its constituent parts. I'd like to get a % similarity of each revision to the active revision. I'm assuming Advanced Analytics Toolbox will be used here to generate some sort of Correlation Coefficient. Here are two sample Revisions.

Bill of Material	Revision	Component	Weight	Active
GuitarStarterPack	0001	Fender	7.5	N
GuitarStarterPack	0001	Amp	15	N
GuitarStarterPack	0001	Pick	.001	N

Bill of Material	Revision	Component	Weight	Active
GuitarStarterPack	0002	Dean	7.2	Y
GuitarStarterPack	0002	Amp	15	Y
GuitarStarterPack	0002	Pick	.001	Y
GuitarStarterPack	0002	Songbook	.3	Y