Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

adjust to show repeat digit T

need adjust this

to work with  any repeat digit

when data in TRI-DATA sheet  hit find 2  example 11

then DTA_OUT   output need be  11 not mixed
T_find234_adjust_to.xlsm
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Martin Liss

What do you mean by "not mixed"?
ADRIANA P

ASKER
Martin

b2222.PNG
ADRIANA P

ASKER
when  show ans count only the 11
Your help has saved me hundreds of hours of internet surfing.
fblack61
Martin Liss

I still don't know what you mean. Please show the results you want when you search for 11.
ADRIANA P

ASKER
Martin

when i  hit find 2 button

i enter 11

then answer should be all numbres with 11 not  481 619

because im lookiing for the 11 only
Martin Liss

Is this just for "Find 2", or is it also for "Find 3"?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Martin

you rigth  !!

it also for "Find 3"

if i look for 111

it show others numbers in the answer
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Great JOB

 Best Expert !!
ADRIANA P

ASKER
Martin

can the clean button be fixed ?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Martin Liss