I know that my english can be better. Please rate my work and not my lack in linguistic skills!

If you find any kind of ownership issue, or you think some content is your property. Please be so kind and contact me, i will remove or solve it ASAP.

You like my free Uploads and want to support me, than please donate here:

Check for dublicates around 2 columns

=(wenn(SVERWEIS(B2;A2:A7;1)=B2;"EXIST";"DOESN'T_EXIST"))


INFO: On english Office Version it's possible that you have to Change "wenn" to "if"

declaration

This simple Formular (in Cell.C2) checks the cell "B2" with the Liste "A2:A7" if there exists the value of B2. when the Formular finds value of B2 exists in table it write in C2 "EXIST" or "DOESN'T EXIST"

XLS-File sample

Download
Mappe.xls
Microsoft Excel Table 23.0 KB
Download

Background

I use this command quit often to check a file list with another. Sometimes on larger Filelist you have to take care that it can be take some longer to check all cells, some patience is requiered than.