Determine if there are duplicate data for each row of cells in Excel 2010

① start Excel2010, see a few lines in the first half of the data, we have to do is to calculate whether each row has the same value, click H2 Cell, enter the formula: =if (OR (COUNTIF (B2:G2,B2:G2) >1), "", "No" & "Same"

② at this time not directly press the ENTER key, but Ctrl+shift+enter key three together, get the result, the same. True one, 二、六三个 month data is the same.

③ then we can double-click the + number fill handle to complete the remaining data records.

Formula meaning

First of all, using the COUNTIF function to calculate the number of data in the B2:g2 region, and then the or function to determine the number of each data, whether more than 1, there are greater than 1, or function will return true, and if the true function returns the result is None, and the same with the same string up the result If the or function is not valid, the IF function returns no concatenation with the same.

Classification:

• Excel Tutorials