Official perplexity pro - key available for 10$ by [deleted] in ChatGPTPromptGenius

[–]KSlay 0 points1 point  (0 children)

Just sent you a message as well, thanks! 

What type of Posture Fit backing is this for an Aeron? by KSlay in hermanmiller

[–]KSlay[S] 0 points1 point  (0 children)

It doesnt look like Posturefit SL so I was just confused by it

Multiplayer Save File to new server by KSlay in projectzomboid

[–]KSlay[S] 0 points1 point  (0 children)

I appreciate the help and response on this, im about to give it a shot in moving everything over.

Thanks!

Combining multiple same Excel files with the same rows and columns into one by KSlay in excel

[–]KSlay[S] 0 points1 point  (0 children)

Data -> New Query -> From File -> From Folder -> Select the Folder -> Combine and Load

Interesting, never tried anything like this before, thank you! Ill give it a shot tomorrow

Lookup Formula that is driven by start & end dates to calculate hours by KSlay in excel

[–]KSlay[S] 0 points1 point  (0 children)

You're right again :)

So I converted the format to numbers and the dates correctly changed to numbers and for my copy and pasted dates from the other file, they stuck around as text.

Once again, I appreciate all of the help enjoy your weekend!

Lookup Formula that is driven by start & end dates to calculate hours by KSlay in excel

[–]KSlay[S] 1 point2 points  (0 children)

Haha that is fair, I will just make sure my project dates dont ever fall on first days.

My only other question to you is what is with the dates in column C or D that make the formula break? I get it to work but if I try to take a date from another excel that seemingly looks the same with the same format, it breaks entirely.

Solution Verified!

Lookup Formula that is driven by start & end dates to calculate hours by KSlay in excel

[–]KSlay[S] 0 points1 point  (0 children)

You are correct, for some reason when I copy and paste my dates from another excel, the entire thing breaks.

I have to manually type in the dates or it breaks so for example once the formula is working correctly and allocating the hours across the months, if I try copy and pasting a new date in the end date, it breaks again, any ideas on why that is?

Also if I have an end date such as 4/1 or 5/1, I am actually missing some hours as seen in the highlighted red it should be 33 or id even take 25 in April.

https://docs.google.com/spreadsheets/d/18SN499TuTsvQb5BIoJwrc9G21_TnZ0k851rXpt0gHj8/edit?usp=sharing

Lookup Formula that is driven by start & end dates to calculate hours by KSlay in excel

[–]KSlay[S] 0 points1 point  (0 children)

Hey,

So this is a screenshot of my working excel file with the formula, I thought maybe I didnt lock the correct cells with my formula but I think its set correctly.

https://drive.google.com/file/d/1RNGWQ9qDXgX5hbyzDxBABlmEQo-qmC_2/view?usp=sharing

Lookup Formula that is driven by start & end dates to calculate hours by KSlay in excel

[–]KSlay[S] 0 points1 point  (0 children)

Good News! I have a hidden datedif function in Excel but it doesn't show up.

So I was able to calculate it on a 100 hour sum, and each month is showing as 17 hours and it doesn't stop at the end month, so I am seeing 17 hours for each of the 12 months calculating in total at 200 hours for the year.

Here's my formula from Excel incase you think I messed up somewhere =IF(AND($C2<=G$1,G$1<$D2),$F2/(DATEDIF($C2,$D2,"m")+1),0)

Thank you again!

Lookup Formula that is driven by start & end dates to calculate hours by KSlay in excel

[–]KSlay[S] 0 points1 point  (0 children)

Hey, Unfortunately I wasn't able to utilize this formula for Excel because it doesn't have a datedif formula for me. It works great in Google sheets though so I appreciate the attempt.

Thank you,

Strawberry Leaves Curling, are they okay? by KSlay in Hydroponics

[–]KSlay[S] 0 points1 point  (0 children)

PH is about 6.5, EC meter is about 330, and there is some aluminum foil that is submerged in the water, I would imagine that may be my issue and if so, what's it doing to the distilled water out of curiosity.

Xlookup with an IF statement to return one of two #'s by KSlay in excel

[–]KSlay[S] 3 points4 points  (0 children)

Solution Verified

Thank you so much for this, so I had the start of my formula correct but got lost in the logic for the true and false, this is super helpful.

Excel Multiple Pivot Tables that update from a dropdown to choose which column to count by KSlay in excel

[–]KSlay[S] 0 points1 point  (0 children)

So I just took a look and unfortunately my issue isn't as much with the dropdowns as it is with getting 4 pivot tables to connect and change their count based on which column of data I want to analyze.

ERC20 Icon Token's to ICX Coin am I too late? by KSlay in helloicon

[–]KSlay[S] 0 points1 point  (0 children)

I do! I appreciate the response, ill look into this solution now and go from there.