Hello
Please have a look.
It will add a 1 into any that is found on sheet 1.
If this is what you are after then you just need to "DATA SORT" and that will group them together.
Again if it is ok and you want a macro to DATA SORT I'll have a look later, please send me a private message to let me know what you want to do.
I noticed all your numbers are stored as text, any reason why.
I didn't have time to see if this has effected the result; if in sheet 1 it istext and sheet 2 is a number, or a mixture of both, if this is the case, we will to change need them to a number.
I really have to go now.
Regards
Peter
Bookmarks