P
P
Pavelneznaet2021-05-26 22:51:28
excel
Pavelneznaet, 2021-05-26 22:51:28

How to select cells with duplicate endings in Excel?

There are multiple urls. It is necessary to select those that have the same ending either by a given number of characters (for example, selecting cells containing the same last characters from the range, or a specific value) or selecting duplicates after the last specified character (in this case, it is a slash "/" ).
For example:
https://testpage/voprosi
https://testpage/category/voprosi
It is necessary that the cells of the selected column containing the same ending - in this case "/voprosi" - be highlighted.
Z.Y. I saw formulas for selecting cells with a partial match of the specified value, but I did not find a similar selection of a partial match of duplicates. If the double could be specified in the formula, it would be easier.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
BasiC2k, 2021-05-27
@BasiC2k

See Conditional Formatting.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question