Need Help With a Formula

[pdom3245]

I'm compiling a spreadsheet with an ever changing list of names. I need to be
able to take the list of user ids and separate them into categories, and how
many are in each category. I do have a list of each of the id’s that I have
on the sheet where the graph will be populated and 2 other sheets where the
info is stored. I need help with a formula. I’m all out of ideas. My problem
is that I can not make it do it for a list of names, but I do not have a
problem when it’s only 1 name.

Please any suggestions would be appreciated. Thanks

 

[Pete_UK]

Despite repeating your post a second time, it still doesn't make much
sense to me. Please try to describe what you have (in terms of data,
cells used etc) and what you want to achieve. List also what you have
tried already and describe what happened if it didn't work.

Pete

 

[pdom3245 via OfficeKB.com]

Sorry - I have a list of ID's, 6 digits Letters and Numbers or just Letters...
i.e N14897 or JLJACK, what I'm needing to do is have a field in the spread
sheet searched and add up any of the id's I have in a list for me.

i.e Spreadsheet:
SBC 2 N33081 3215200 R
DENTAL DENADJ 3208168 O
DENTAL N47057 2466070 R
SBC 1 DENELG 2464670 O
SBC 1 B96569 3174648 O

List:
N79903
N81854
N68375
JLJACK
N32202
N80971
N59579
DLPHIP
C07763
C9CMS1
N83885
VXTREV

take my list and have it seach column B to add up all the names on the list

Despite repeating your post a second time, it still doesn't make much
sense to me. Please try to describe what you have (in terms of data,
cells used etc) and what you want to achieve. List also what you have
tried already and describe what happened if it didn't work.

Pete

I'm compiling a spreadsheet with an ever changing list of names. I need to be
able to take the list of user ids and separate them into categories, and how

[quoted text clipped - 5 lines]

Please any suggestions would be appreciated. Thanks