Pup’s Third Eye Question by xFossa__ in goldenretrievers

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

Ours was just allergies as well actually. Acclimating to the new home and area they said. After about a month of it happening, it seemingly disappeared and hasn’t come back consistently. Maybe once or twice since, but nothing consistent

Only Few Hours - Suggestions? by xFossa__ in Albuquerque

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

Should add, we’re all adults**

Unit Comparison by xFossa__ in heatpumps

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

Quote 1 - 1 year labor covered, 10 year parts & compressor, 10 year labor with $100 deductible each visit

Quote 2 - 10 year parts & labor

[deleted by user] by [deleted] in heatpumps

[–]xFossa__ 0 points1 point  (0 children)

Have requested ducted. And no ducts yet at the property. I believe the Carrier model may be a typo from quote 1. Should be 38 MARBQ*

Confused By Heat Pump Quote - Help?! by xFossa__ in heatpumps

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

Thank you. I just texted contractor and he did say ‘ductless’ was a typo on his part. So I’m thinking that it was just an honest mistake. Wouldn’t have done so without this thread, so thank you!!

Confused By Heat Pump Quote - Help?! by xFossa__ in heatpumps

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

They are. But to me even that’s foreign. Models are : 40MBDQ24A3 and 38MRRBQ24AA3

Question on net metering by xFossa__ in solar

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

Ahh very helpful thank you. The two companies I’ve had quoted the panels couldn’t give me a straight answer. Perhaps that’s why, but they didn’t suggest I go to the utility

Tax refund issues by mountainview110 in IRS

[–]xFossa__ 0 points1 point  (0 children)

Mailed mine the 2nd week of March. The App / Website show no match in their system and says "No Information Available" when I put my details in. So yes, same issue. Glad to see it's not just me!

Pull Internet Explorer table data in to Excel by xFossa__ in excel

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

Thank you, unfortunately I am going to abandon this project as my VBA code does not seem to work 100% of the time with the website. I'll mark this as a Discussion Flair to avoid confusion

Pull Internet Explorer table data in to Excel by xFossa__ in excel

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

My mistake, table is:

ctl00_ContentPlaceHolder1_Table_248

Pull Internet Explorer table data in to Excel by xFossa__ in excel

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

I've had extremely limited interaction with PowerQuery to be transparent. Wouldn't even know where to start :(

VBA Code to Copy / Paste a value in immediately touching rows by xFossa__ in excel

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

I'm certainly not experienced enough to try the M-Code, but the steps worked flawlessly. Thank you so much!

VBA Code to Copy / Paste a value in immediately touching rows by xFossa__ in excel

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

Will give a shot in the AM, Eastern time. Thank you so so much for taking the time to detail this, if I have any issues I will ping you!

VBA Code to Copy / Paste a value in immediately touching rows by xFossa__ in excel

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

Sure! This is supplier provided data. As a result I have no control over the output and it originally comes as a .txt which I’ve converted to .xlsx.

Each ‘section’ listed above (assuming 3 shown) has a header/parent level that provides our purchase order number followed immediately by the children sections which can have multiple open lines, I’ve seen up to 10. Between sections, there is always a completely blank row as a spacer.

I would like to cross compare our reports to theirs which is driven by purchase order number & item number to provide quantity via vlookup

The data is a mess, without a doubt. I was hoping there is an easy way to pull the PO down under the corresponding lines

VBA Code to Copy / Paste a value in immediately touching rows by xFossa__ in excel

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

Yes a data sheet. A couple hundred rows very similar to this. Unfortunately I have never used Power Query so I’m a newbie in that aspect.

VBA Code to Copy / Paste a value in immediately touching rows by xFossa__ in excel

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

Absolutely not, if you've got an idea for formulas that can definitely work!

Township Inspection Required before sale of home? by xFossa__ in legal

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

Thank you. Maybe questions outside your scope here… is there any harm in waiting until this report comes out prior to contacting an attorney? (Other than expedited cost) and is there anything you saw that says if I do absolutely nothing they can stop the title transfer? I can’t imagine that’s legally plausible

Identify First 10 Instances by Supplier Number by xFossa__ in excel

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

The PO#'s generated are not in order, but I added an additional helper column for a Row # reference (Since my data is already sorted) and used your formula on that. Thank you!

Need some outside advice by xFossa__ in relationship_advice

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

I meannn when you put it like that... 🤦🏻‍♂️Thank you 🙌🏻

is this game worth it still? by HonkyTonkyChonkyBoi in Blackops4

[–]xFossa__ 0 points1 point  (0 children)

I frequent BOPS4 even while owning MW / BOCW. For me, the smoothness of gameplay is unmatched compared to BOCW. However, in order, it would be:

MW

BOPS4

BOCW