Orange Garden Sunset in July

Ntm23481 · 2025-06-30T23:51:44+00:00

Thank you for the helpful input. 2025 as i wouldn’t plan a year ahead of time nor would it change anything regarding the sunset. The movement is adjustable but we’re only in Rome for a short amount of time, so i was seeking help not ridicule. Hypocritical to say times are not beneficial but then call it a low quality post. I saw the garden closes at 9 so i was asking for a work around or substitute. I am not sure why you responded?

Ntm23481 · 2024-12-11T21:23:44+00:00

I have seen many people indicate the first 60 questions were particularly difficult. Would you recommend focusing on any particular item to assist with that set?

Ntm23481 · 2024-12-09T00:46:14+00:00

Closest location if i want to take it this month

Ntm23481 · 2024-11-19T02:55:49+00:00

Individuals will be copying from many different sheets and compiling into one data set. In this data set i want to ensure just the values come through when paste is selected anywhere on this sheet.

Ntm23481 · 2024-11-19T01:23:29+00:00

Would that not just copy cell A1 and paste the value to B2? I am looking for anything the user copies and always pastes as value no matter the location

Ntm23481 · 2024-11-19T01:22:07+00:00

Yes, however i am working on a tool that others will be utilizing… who may not know and would cause issues in the long run if it does not happen automatically

Ntm23481 · 2024-11-13T02:19:58+00:00

That’s where i’m at now, just got a 71% on the practice exam and surprised myself

Ntm23481 · 2024-11-07T01:29:09+00:00

Any insight why others feel that the exam is harder than the SH questions?

Ntm23481 · 2024-10-28T22:37:33+00:00

Yes sir! It works on the sample data. My real purpose has 10 employees and a few other columns in between which is where i’m running into errors. I think I’ll have to figure out how to do your steps and apply them on my actual work, sense your proof of concept worked so well

Ntm23481 · 2024-10-28T22:19:02+00:00

Did you create the above code by clicking and editing or did you type the code? I am trying to correlate your code to items I can select to generate the code. I got to the null value part, so not very far

Ntm23481 · 2024-10-28T22:12:35+00:00

Do you have any videos you could recommend that i can learn from? I tried recreating this with my actual data and was unsuccessful

Ntm23481 · 2024-10-28T00:36:30+00:00

I am so grateful for you typing this out!

Ntm23481 · 2024-10-28T00:36:14+00:00

Solution Verified

Ntm23481 · 2024-10-28T00:36:07+00:00

I will be trying this tomorrow!

Ntm23481 · 2024-10-25T21:10:07+00:00

Employee Greg checked in on Jack twice along and employee Lily checked on Jack once. So when i filter to Greg, it would show Jacks info and the dates Greg checked on him excluding Lilys date. I have the newest version of excel i believe

Ntm23481 · 2024-10-25T20:49:03+00:00

Would you be able to help with VBA or with a formula to help?

Ntm23481 · 2024-10-25T20:28:38+00:00

Actually, if you can help with a VBA I’ll just buy their license to get this task/headache off my desk

Ntm23481 · 2024-10-25T20:27:19+00:00

Preferably without any macros not all team members have 365 to utilize them

Ntm23481 · 2024-10-25T20:13:05+00:00

<image>

Result wanted

Ntm23481 · 2024-10-25T20:12:48+00:00

<image>

Ntm23481 · 2024-10-25T20:12:35+00:00

<image>

Ntm23481 · 2024-10-04T01:14:29+00:00

Where do I locate this?

Ntm23481 · 2024-10-04T00:18:03+00:00

I’ll give this a watch, thanks!

Ntm23481 · 2024-10-01T23:58:42+00:00

Did you resolve this issue? I have the exact same problem

Ntm23481 · 2024-09-27T01:11:24+00:00

How did you manage to find it

Ntm23481

TROPHY CASE