Question description:
This user has given permission to use the problem statement for this
blog.
I have 500 numbers in column A with aproximatly 15digits.
In column B I have 5 numbers with 6 digits
Can a find a formula wich can transfer all numbers from A column wich start with some 6 digitsa from B column
Solved by V. L. in 32 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
25/03/2018 - 11:43
2013
User
25/03/2018 - 11:43
more than 1 hr
Excelchat Expert
25/03/2018 - 11:44
Hello
User
25/03/2018 - 11:44
can I show on the scree here like example what I need?
User
25/03/2018 - 11:44
hello
Excelchat Expert
25/03/2018 - 11:44
So can you share the file
Excelchat Expert
25/03/2018 - 11:44
Yes sure
User
25/03/2018 - 11:44
no
User
25/03/2018 - 11:44
ok I'll show
User
25/03/2018 - 11:44
1 min
User
25/03/2018 - 11:45
like that
User
25/03/2018 - 11:45
but my column]
User
25/03/2018 - 11:45
A
User
25/03/2018 - 11:46
is very big
User
25/03/2018 - 11:46
every day
User
25/03/2018 - 11:46
Is hard to fiind everytime
User
25/03/2018 - 11:46
I need a formula who can find all numbers from A wich start with B numbers
User
25/03/2018 - 11:46
and transfer in C ALL
User
25/03/2018 - 11:46
all
Excelchat Expert
25/03/2018 - 11:47
Hmm, I see
User
25/03/2018 - 11:47
I think is VLOOKUP here
Excelchat Expert
25/03/2018 - 11:47
how many numbers are there in B?
User
25/03/2018 - 11:48
every day different
User
25/03/2018 - 11:48
t aproximatly 20
User
25/03/2018 - 11:49
and in A column can be 500 or 1000
Excelchat Expert
25/03/2018 - 11:49
let me think a bit
User
25/03/2018 - 11:49
ok
User
25/03/2018 - 12:04
sorry, are you still here?
Excelchat Expert
25/03/2018 - 12:06
yes, just wait a bit more
User
25/03/2018 - 12:06
ok sorry
Excelchat Expert
25/03/2018 - 12:13
here
[Uploaded an Excel file]
Excelchat Expert
25/03/2018 - 12:14
there are two extra columns D and E
Excelchat Expert
25/03/2018 - 12:14
You can hide those
Excelchat Expert
25/03/2018 - 12:14
So what D is doing is extracting the first 6 digit of A
Excelchat Expert
25/03/2018 - 12:15
and after that I am copy pasting D in E as "Values"....
User
25/03/2018 - 12:15
ok thank you very very much
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.