Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question