9.5 Count number of repetitions of row-based data - by key column


Here below is a personnel data table:


To count the number of duplicate data (the judging basis is that the data in the Name field are the same), enter the formula in the cell E2:


Then drag E2 down to every relevant row: