Find Data in column

ADRIANA P
ADRIANA P used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
What should the output look like?
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
I made the output look like it did in some of your other workbooks.
29116581.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

29116581.xlsm

work as needed

but not find button are
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
in this way
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Download the workbook again. There is a button.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job !
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
But if you want to do

it  you can
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I corrected a problem where if you searched for 11, 22, etc., you'd get a lot of incorrect results.
29096485a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

file 29096485a.xlsm  don't  belong  to me
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job

Best Expert

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial