Essentially, I have two lists of Hospital systems that I need to consolidate into one comprehensive list. so far I have created a sheet using an =IF(ISNA(MATCH... sequence that gave me a match or no match read out. From here I'm looking to find the discrepancies between the two (i made a cell that reads out 204). Unfortunately, it's not simply a matter of using the longer list because the smaller list may have systems that are not included in the larger. I was thinking if i could have excel sort of separate the matched and extraneous systems into two columns I could work from there? help? attached is what I have so far. All help would be greatly appreciated! thank you
Bookmarks