[mister J]

If this is posted in the wrong forum, accept my apologies and move this to the appropriate forum.

So basically I have a question about two lists of people in excel. All entries are Text fields.

file 1.xls has a list of names, file 2.xls has a list of names divided into categories.

Now all I have to do is crosscheck if the name in the first list exists in the second list, and if so, tally what category they exist.

Example:


List 1
Joe B.
Sam C.
Jenny J.

List 2
Mark F. (rich)
Sam C. (poor)
Jenny J. (rich)

so the tally would go:
poor - 1
rich - 1
not counted - 1

I was wondering if there was a way to streamline the process. Instead of counting hundreds of names manually.

[Klaustrophobia]

i'm not sure excel can search for strings.  but you could write a very simple program to read the data out of text files and do the tally.

[headdie]

you could do it with vlookups searching each catagory nested in if statments to get the proor/rich for the list of names then probably use something like countif to tally them up

[mister J]

ah, thanks! that was pretty much it.