ExcelBanter - finding common numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - finding common numbers (https://www.excelbanter.com/excel-discussion-misc-queries/202687-finding-common-numbers.html)

Free Rider[_2_]

finding common numbers

I have a list of numerical entries, each entry conaining four digits. How
can I find any entries that have 3 common digits?

Pete_UK

finding common numbers

Is the position of the digit important, so that 1234 and 4321 would
have none in common?

Pete

On Sep 16, 4:14*pm, Free Rider
wrote:
I have a list of numerical entries, each entry conaining four digits. *How
can I find any entries that have 3 common digits?

All times are GMT +1. The time now is 01:07 AM.