Hello.
How can I compare values in columns NUMEPRENUME, CNP from the worksheet BAZALUCRU with the columns Nume2 and CNP2 from the worksheet referinta2, and display values that are repeated only once and those that are not repeated to be displayed below them separate?
If it is a combination of name and CNP that make a record unique, you will need to make what I call a "composite key" from them. Composite Key is a database term and the idea is similar. In this case we add a helper column in each table with the formula: =TRIM(A2)&":"&B2. I put a colon ( : ) between the two parts to make it easier to read. I had to use TRIM because some of the names have extra spaces in them.
Then we compare composites using =ISNUMBER(MATCH(G2,referinta2!$E$2:$E$591,0)) This formula is true if the name is found on the other list and false if it is not.
You can filter on the list to get the rows you want.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks