Suppose in Excel I enter data, for example phone numbers.

What type of function to enter, which, when entering an already existing number, will report an error, or simply report it in the adjacent column?

  • @ Avaz Benjamin, If you are given a comprehensive answer, mark it as correct (click on the check mark next to the selected answer). - Vitalina

2 answers 2

=СЧЕТЕСЛИ(диапазон;новый_номер)>0 =ЕЧИСЛО(ПОИСКПОЗ(новый_номер;диапазон;))

TRUE - there is such a number.

It is possible to apply the Data_check tool ( Data tab) to the cells into which numbers are entered using a similar formula.

If on a sheet, you can add a check:

 =ЕСЛИ(СЧЕТЕСЛИ(диапазон;новый_номер);"уже есть";"порядок")

    I did differently in Microsoft Office 2007.

    Allocated the entire column, even blank lines.
    Then on the tab "Home" chose - "Conditional Formatting".
    Further chose - "Rules for the selection of cells."
    Further - "Duplicate values".
    Then I chose how to select and click OK.
    That's all, all repetitions will be highlighted in color.