# 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
ACCOUNTING ASSISTANTAsked:
###### Who is Participating?

Older than dirtCommented:
OK then try this.
29075976.xlsm
1

Older than dirtCommented:
Haven't we done that before?
1

ACCOUNTING ASSISTANTAuthor Commented:
Martin Liss Not Yet
0

ACCOUNTING ASSISTANTAuthor Commented:
289 in any combination

pick up the number with it
lets say  289X , 28X9 , 2X89,  X289  ect...
0

Older than dirtCommented:
In all the workbooks I've helped you with, don't we already have a "Find 3" button?
0

ACCOUNTING 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

ACCOUNTING 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

ACCOUNTING ASSISTANTAuthor Commented:
Best Expert Always !!
0

Older 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

ACCOUNTING 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.

## Already a member? Login.

All Courses

From novice to tech pro — start learning today.