assistance with Artist Databasing.

Maybe something like this would work:

On Sheet1:
Col_A contains ARTIST (including variations of names)
Cell A1: Artist

Now....on Sheet2

A1: ListName
B1: ReportName

• Under cell A1, only enter artists with name variations
(If an artist is only listed as one name....do not list it here)
• Under cell B1, enter the consolidated name.

Example:
A2: BOB MARLEY
B2: Marley, Bob
A3: BOB MARLEY & THE WAI
B3: Marley, Bob
A4: MARLEY, BOB
A5: Marley, Bob
etc

Ok...back to Sheet1:
B1: ReportName

Please Login or Register  to view this content.

Copy B2 down as far as you need (7,000 rows, right?)

Last, set up a pivot table to tally the counts for you...
Here's how:

From the Excel Main Menu: <Data><Pivot Table>
Use: Excel……Click [Next]
Select your data (A1 thru B7000)……Click [Next]
Click the [Layout] button

ROW:
Drag the ReportName field here
Drag the Artist field under the ReportName field
COLUMN: (leave this area blank)
DATA: Drag the Artist field here
If it doesn't list as Count of Artist...dbl-click it and set it to Count
Click [OK]
Select where you want the Pivot Table…Click [Finish].

That will list each ReportName and any associated Artist names and the
counts for each. Adjust the pivot table subtotals according to your
preference.

To refresh the Pivot Table, just right click it and select Refresh Data

Does that help?
Post back if you have more questions.

Pivot Table Links:
http://www.nickhodge.co.uk/gui/datam...ablereport.htm
http://www.contextures.com/tiptech.html

JWhit, this is the formula I wrote for the databasing:

=IF(ISERROR(AND(FIND("BOB",Data!A10:A44389),FIND("MARLEY",Data!A10:A44389))),1,0)

It returned to me a "1" but I know that there are more than one instance where "BOB" and "MARLEY" are logged. I think I poorly explained what I need to do. In cell C93 I put the formula down.

As for Ron, I tried that out and it worked fine but I would have to look for every instance of the variation of the name and I'm trying not to do that. It's my fault, I don't think I explained it well. I will attach the actual document do you guys can see what I mean.


Edit: I just found out that I can only upload 1MB of an .xls file. Can I have your e-mail addresses so I can send you the file I'm working on? It's just under 7MB.

Thank you.

I understand the problem you're facing. However, there's no elegant workaround (that I know of) to building a Cross-Reference table. Any other formulaic approach would be too bloated to work with (if it even fit in a cell) AND would still not return accurate results.