We help IT Professionals succeed at work.

adjust file to find 00

77 Views
Last Modified: 2018-09-17
when i hit 00 to get the results in sheet 2

is not working properly and need eliminated the arrows too

x33333.PNG2n_fix_00_.xlsm
Comment
Watch Question

Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Do you want the results in ORD order?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

 yes !
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Here are my results. Row 2922 (and probably others) are different than yours.
29118287.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
still not working

yyy222.PNG
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please pick a row and show me what the numbers should be.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
all 00  in the list should be show
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Tell me a row number that is missing.
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I checked. Every cell in column 'A' that contains a zero has results in columns 'C' to 'J'.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i dont see any change from the original file to the one you posted

still have the same error
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
this is how should be after fixed
zzzzz111111.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Here are my results. Row 2922 (and probably others) are different than yours.
29118287.xlsm


this file dont  work like that
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
still have the same error
You haven't told me what the error is. All you said is that "all 00  in the list should be show". Please give me more information. Are you saying that Sheet1 is wrong or is it Sheet2 that's wrong? If it's Sheet2, tell me what's wrong with it.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
like i say   and show  up
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Are you trying to tell me that you get an error when you double-click a "00" cell?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Are you trying to tell me that you get an error when you double-click a "00" cell?

Yes!
Social distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JoB

! best expert
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
why the file is not showing the colors by week ??zzz22222.PNG

as it was??
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
"I can change it back if you want me to."

great job !!

is good to me


but need keep the color track as it was Martin
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Working as needed

 Best Expert

alot of details  but you the best !
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
still don't work
when i  double clik nothing happens

you did this before is nothing new
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please don't make me guess. What exactly doesn't work.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
any number in column A
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You are still making me guess. What sheet? Double-click? I need complete information.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
sheet 1
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You STILL haven't told me what is wrong.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
asd.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i have to repeat all over
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
can you please test the file i upload

2n_fix_00_.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i have just problem with 00 but the others num  was working good

that the reason i mention just the 00
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
THAT'S the kind of information that stops me from having to guess.

Instead of double-clicking, just click the new  ‘Find “00”’ button.
There are no more arrows anywhere.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

the file i upload worked with any num

then now not

why ??
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
the only correction needed was with 00

but i don't want the others as was
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
and eliminated the arrows
you already did
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
but i don't want to change the others as it  was upload at first
to be fixed
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
In some of your workbooks, only double-clicking "00" did anything so that's what I did for this one, and since you never said something like "When I double-click ANY number in columns 'A' of Sheet1, I need to see data in Sheet2", I had no idea that that was what you wanted.

I'll make the change, but please don't give me any more points in this question.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
When I double-click ANY number in columns 'A' of Sheet1, I need to see data in Sheet2", I had no idea that that was what you wanted

sorry  Best Expert

as the file is working good as needed

  but  not when an 00 num have to be
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JOb

working as needed

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.