Awesome, did more digging and it turns out it's an HRV and likely not something I need to be running during the summer months as I don't need more warm air circulating and we keep windows open often enough to naturally exchange the air.

Yeah it goes back in place and fits perfectly once i push it back into place. I'll go the glue and nail route. Thanks!

I tend to lean towards it being humidity since we have only noticed it happened in the last couple of weeks where temperatures in this area are higher than normal, humid and our AC has not been working for months (just had it repaired today).

This worked exactly as I needed it to. Thanks so much!

I figured it out!

I had to make my drop down list data a table in the other sheet, and then in the cell i wanted to be the relative drop down i did Data Validation > List and within source i entered =INDIRECT("TaskLists[" & $K2 & "]") referencing the table i created.

I don't think I am capable of understanding the mindset of seeing Trump and how little he has given to his supporters and the clear damage he is doing across everything, being on the outside and thinking "I want that."

I can understand experiencing hard times and wanting change, but to look at Trumpism and see it as an oasis I cannot understand. What do they have that you want? What do you think he will offer you that he won't rescind?

Ah good point, I didn't think of the consequences of mixing the different air temperatures through the ducts. Ideally I would like to avoid blowing mold all throughout my children's bedrooms.

Thanks! Just bought a Bissell Little Green pro heat cleaner on sale to tackle this.

yeah it absolutely has to have the .000 because it will be using that to reference another database to sync based on that client id. How do I convert numbers to strings?

They decided to start a war knowing their defensive tools were already critically low... Was the plan really all just hubris thinking Iran would just rollover in 24 hours? Even a child playing a FPS knows to reload their weapon before going on the attack.

Yeah i think the format of the sheet I was using was out of whack based on all my attempts at correcting it, I was able to paste into a brand new sheet and got the results I needed using another users suggestion of =TEXT(B2, "0.000") which was a success! Thanks for the guidance!

Yeah not the most handy person and electrical freaks me out so expecting the higher cost of having a professional do it but luckily where i live (Canada) there are federal programs that offer rebates on things like this if the options we choose are eco friendly so, might be expensive but we should get money back providing we follow the regulations.

Unfortunately with the house layout there isn't a good spot to put a fan at the top of the stairs as it will block the narrow hallway that exists between the bedrooms as well can't put it on the stairs because they are spiral.

Not coming off as obtuse, and i'll try my best to explain the issue but I do understand what you are saying.

The goal is I am doing an import of clients into our system for an integration so the info syncs correctly and we sync using the Client ID, which is case sensitive.

When I imported the data into my system, i want to import the Client ID - 1105416.000 (what i see in the cell). When using my importer tool to match the corresponding fields in our system with the field in the spreadsheet, the value example the importer tool is showing is Client ID - 1105416, which is incorrect. I ran a small sample to test and it imported as 1105416, but it has to be 1105416.000

ChatGPT gave me the same suggestion but didn't fix the issue.

None of these were really helpful or achieved what i needed. Articles weren't clear on how to apply these functions to datasets that weren't perfect matches to the examples shown.

Essentially, i want to merge all duplicates of project id, task name, task start date, task end date into a single row with the hours being a total of each duplicate row

Is there any tutorial you can link me to better understand this process? Unsure what VBA is.

You really believe Denmark is looking at the Trump's administration approach as something to model itself after? What are the common issues Denmark is facing that match the US response?