How to identify duplicate text in a range?
By using an appropriate query.
For a more detailed answer, please post a more detailed question. What's the
structure of your table? What kind of "duplicates" - duplicated substrings
within a text field, records with duplicate values in a text field, duplicates
from one field to a different field? Any of these can be done, but in
different ways.