look for 3 numbers

i have an list of numbers

then need  look for all  the numbers that make that combination

example
need all the 289 combination from the list
90890.xlsx
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
OK then try this.
29075976.xlsm
1
 
Martin LissOlder than dirtCommented:
Haven't we done that before?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin Liss Not Yet
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
289 in any combination

pick up the number with it
lets say  289X , 28X9 , 2X89,  X289  ect...
0
 
Martin LissOlder than dirtCommented:
In all the workbooks I've helped you with, don't we already have a "Find 3" button?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
well this situation is  not like others  Martin Liss
 

 in this solution all the numbers  area in diferents columns
and i need get the  any combination
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin Liss
Great Solution Like Always

but  need  to make some improves


for examples  

1-can be show the how many times the number repeat??
2- can be show from what columns it becomes ??

i mean can it be done??


the numbers area will be the same but
list number can grown or shrink as needed
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Best Expert Always !!
0
 
Martin LissOlder than dirtCommented:
This version counts the number found and puts the column letter in column "B". I could put the cell address just as easily.
29075976a.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
You Lead The Way ! Martin LIss

Working as needed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.