How to identify non-matches

Ok,

I have no specific data set yet to share, but I have a project coming up and I need to determine if I can perform a function in Excel or if I will have to revert to Access. The data is already in Excel and the number of records will not be extremely large, so I would rather do this in Excel if possible.

The basic calculation is that I will need to evaluate two sets of unique part (item) numbers (which I anticipate to be in text format) to isolate parts from list #1 that do not match parts numbers from list #2.

My question is if anyone knows ( or could recommend) the most efficient manner in which to do this. I figure the worst case scenario is that I could identify the matches and remove these from the list through a sort function, but would love to be able to get my results through a more efficient manner if possible.

Any thoughts?

Hi

See Parsnip's posts in the following thread (the one with the attachment) for one possibility:

http://www.ozgrid.com/forum/showthread.php?t=77529

Richard

Thanks! I think this may work, it appears to do what I need. Once I get my data, I will see what happens

Thanks!

Everything has been good so far, but now I need help with a formula to perform a conditional count. I have two columns (highlighted in yellow in the attached example) that I want to evaluate. I will need to determine if the number of months (which is displayed in column "C") falls below, within and above three different ranges...see chart in Column "F" & "G". However, I want this based off of the type of Equipment Class.

For example, in cell G3, I want to know how many Equip Class PC10's in column "A" were less than or equal to 36 months in column "C". I want this to be a count, I know in this data set is should be zero. I want to apply this calculation for each range in the table.

I have attempted a countif function, but can not get it to work properly. Need help...

Thank you for your help. This does exactly what I was trying to do.