
Hi @Kimberly
In B2 (and copy down):
=SUMPRODUCT(--(A$2:A$17=A2)) > 1
NB: Be carreful with SUMPRODUCT, avoid something like:
=SUMPRODUCT(--(A:A=A2)) > 1
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have 16 numbers that have to be formatted as text to display in Excel. What can I do to check for duplicates when they are all in the same column?
@Kimberly
Please refer to Lz-3068‘s answer.
In addition, I would provide another formula based on Lz-3068‘s sample.
You may add an auxiliary column, enter the formula in B2 to mark the repeated text.
=IF(COUNTIF(A:A,A2&"*")>1,"Repeated"," ")
Then you can use Filter to select duplicate rows.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.