9.2 Judge duplication of row-based data - by key column


Here below is a personnel data table:


Judge whether there are duplicate data, if so, fill in 1 in corresponding Dup field, otherwise fill in 0 (the judging basis is that the data in the Name field are the same). Enter the formula in cell E2:


Then drag E2 down to every relevant row: