match lookup index: exception/non exception report

[melinda]

Good morning All,
Update, making progress on the attached spread sheet however still need further assistance.
Goal is to display Match & Unmatched Cusips from same spread sheet.
a-d no change- fixed data
f-I no change-fixed date
*cannot for the life of me figure out how to display Cusips that don't match from section a-d to f-I.
**finally, in column L-M, the only match is that the Cusip matches, is there a way to highlight M-O if it is not an exact match to bank or
***********better yet give me a list by Cusip of Security Description, Coupon Rate and Maturity Rate Differences (K-O)???

 

[John()]

ok think this covers every thing ... matched cuisps are in the matched section ... i have two sections then for the missing cuisps
conditional formatting on first two sections shows duplicates you can continue that but not really necessary
when you add more to colums F to I all other sections will update and change
when you get close to the 2000 row mark in A to I update formula to extend beyond the 2000 row limit
if you dont want the empty rows in the sections post and if i cant sort it sure somebody will be able to (i should be able to adjust my formulas to do this just have to have a further look at formulas where iv seen it done and adapt mine)
as it is you can see where the missing one are coming from by looking accross to begenning of the rows.
anyway hope this helps you out

 

[John()]

ok didnt add file will try again ... cant figure out why your file is so big ... recopied to another work book and its now so much s