Good Morning
The attached worksheet contains the record number (A) and organization number (B) for 1997 and (D) and (E) for 2010. I have been using conditional formatting to identify common organizational numbers for 1997 and 2010. I then manually delete each organizational number and corresponding record number for organizations not found in both years. Is it possible to write a formula or macro (the latter is less desirable due to newbie skill level) that eliminates unique organizations and their corresponding record numbers? I have tried filtering on color or the lack there of but it only filters out the values in one column. And frankly, I have experienced problems working with filtered data.
Thank you for taking the time to read and/or respond to this request.
Al Charbonneau
Bookmarks