finding common numbers

  • Thread starter Thread starter Free Rider
  • Start date Start date
F

Free Rider

I have a list of numerical entries, each entry conaining four digits. How
can I find any entries that have 3 common digits?
 
Is the position of the digit important, so that 1234 and 4321 would
have none in common?

Pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort numbers 3
vlookup/matching? much help needed! 7
Setting Data Validation 2
Most and least common 1
How can I sort a list of numbers by the last 4 digits? 2
I can't sort data when the key column cells contain formula 6
duplicate numbers in a column 2
vlookup with numeric and alphanumeric identifiers in lookup_value 1

Back
Top