In the perfect world cells A1:A3 should have the indentical Special Num in column "C". In some cases like you see in the attached they are not, is there a way we can identify if they are a match or if they are not?
In the perfect world cells A1:A3 should have the indentical Special Num in column "C". In some cases like you see in the attached they are not, is there a way we can identify if they are a match or if they are not?
Can you attach what the end result will look like? I don't quiet understand what are you trying to do.
See attached, basically if a cells in column "B" are identical I need column "C" to be as well... if their not then I need to know.
Last edited by jgomez; 07-24-2013 at 01:11 PM.
In E2 enter =IF(COUNTIF($B$2:$B$9,B2)=SUM(IF($B$2:$B$9=B2,IF($C$2:$C$9=C2,1,0))), "Yes","Borrower has identical SSNEIN but different Special Num") with Ctrl + Shift + Enter keys entering together since it is an array formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks