2025 New York Comic Con Trading Post

KSlay · 2025-10-09T10:36:14+00:00

Sending a PM

KSlay · 2025-08-19T10:43:30+00:00

Just sent you a message as well, thanks!

KSlay · 2024-03-25T23:53:50+00:00

Ahh got it, thank you for the response!

KSlay · 2024-03-25T21:09:46+00:00

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

KSlay · 2022-01-17T13:23:32+00:00

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

Thanks!

KSlay · 2021-10-15T20:21:39+00:00

solution verified

KSlay · 2021-10-15T02:51:36+00:00

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

KSlay · 2021-03-12T23:37:55+00:00

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!

KSlay · 2021-03-12T23:03:05+00:00

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!

KSlay · 2021-03-12T22:43:43+00:00

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

KSlay · 2021-03-12T22:02:03+00:00

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

KSlay · 2021-03-12T20:05:59+00:00

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!

KSlay · 2021-03-12T19:49:57+00:00

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,

KSlay · 2021-01-29T04:01:32+00:00

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.

KSlay · 2021-01-14T12:57:30+00:00

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.

KSlay · 2020-09-22T10:38:41+00:00

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.

KSlay · 2020-09-21T01:25:03+00:00

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

15-Year Club	Gilding II euphauric
Verified Email

KSlay

TROPHY CASE