Previous Topic Next Topic

Copy the number matched to another column

Closed
binoddai Posts 2 Registration date Thursday May 5, 2016 Status Member Last seen May 5, 2016 - May 5, 2016 at 01:02 PM
binoddai Posts 2 Registration date Thursday May 5, 2016 Status Member Last seen May 5, 2016 - May 5, 2016 at 09:41 PM
Hello,

I want help from world.i want to copy the list of number to other column which are match in original column.
Start no 974314567 copy the no which is first 4 numbers match to another column .if 9743 match then copy the whole no 974314567 in another column.if not do not copy . Thanks pls anyone help me.

2 responses

Answer 1 / 2
binoddai Posts 2 Registration date Thursday May 5, 2016 Status Member Last seen May 5, 2016 1
May 5, 2016 at 09:41 PM
Thanks a lot , these are the column list of numbers
examples
9743134567
9744556765
9743245675
9744567890
9743123456

I want to copy the numbers in another new column like this which match from the first 4 digits 9743

9743134567
9743245675
9743123456
I hope to get the solution pls.
Answer 2 / 2
xpcman Posts 19528 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,824
May 5, 2016 at 05:34 PM
Sorry we have no idea what you are trying to do.

Similar discussions

VBA find column by name and sort
SidK -
bOFILL -

4 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response
my account closed.
hayuBdeg -
Ambucias -

1 response
Facebook id confirmation
Sonysahil -
HelpiOS -

1 response