Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

Find Data in column

have an column A call ORD

need find in the column  numbers 47  in any position 47XX,   X47X     XX47   4X7X     4XX7  

and be show  as column in BYSETS sheet

data will grown in column A as more will be addded
BYSETS_TO.xlsx
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

What should the output look like?
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ADRIANA P

ASKER

Martin

29116581.xlsm

work as needed

but not find button are
in this way
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Would it help you if I made it so that if you click on one of the numbers in the BYSETS sheet that it would take you to that number on the DTA sheet?
Great Job !
Would it help you if I made it so that if you click on one of the numbers in the BYSETS sheet that it would take you to that number on the DTA sheet?

in this situation it wont help me
But if you want to do

it  you can
I corrected a problem where if you searched for 11, 22, etc., you'd get a lot of incorrect results.
29096485a.xlsm
Martin

file 29096485a.xlsm  don't  belong  to me
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great Job

Best Expert