I have a spreadsheet with 7000 rows. Each row represents an item of music, ie. either a CD, Vinyl Disc or a Cassette
Each row has an Object ID in column A. Column B is to input the Band ID
There are then columns for each musician that is attached to each object. There may be ten to twelve musicians per object, but generally about 6.
Many of the musicians have played in the same group or band, although the bands may have different names.
I want to search the spreadsheet and define common groups of musicians and allocate a Band ID to those musicians.
How do I go about this task in an automated format
Bookmarks