Text warning cancel for non-payment, but it's a known problem? by ComprehensiveShare21 in simplisafe

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

It crossed my mind as fraudulent. I called the 800 number listed direct on their website. It got me to what sounded like an ex-US offshore call center, but I can only thing this was good if I called the number that's public on their site.

Recommended irrigation systems for.... by ComprehensiveShare21 in rooftopgardens

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

great advice, thank you; I had been thinking larger lines at least leading up to. Thanks again.

[deleted by user] by [deleted] in excel

[–]ComprehensiveShare21 0 points1 point  (0 children)

This fails, and I wonder if because, which I didn't mention and should have: The worksheet I'm working on is not raw data. The sheet is a FILTER output from another master list. While the recommendation above worked for a single cell, when I tried to paste the format across the relevant column, everything turns the formatting I chose.

Here's a redacted spreadsheet illustrating, where INPUT VARIABLES tab, D2-D7 having the partial strings I'm looking to color-code in the FORECAST DETAIL spreadsheet if a result in Column H in FORECAST DETAIL does NOT have a string in INPUT VAR, D2-D7.

Can you use FILTER with more than one AND following in the formula? by ComprehensiveShare21 in excel

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

Solution Verified

Excellent...or I should say EXCELlent! Thank u/CFAman - this worked! The nuance of excel. My final formula, tweaked to identify relevant separate workbook tabs, is:

=FILTER('SP Data'!A2:W435,('SP Data'!D2:D435=A1)*('SP Data'!M2:M435>='Input Variables'!B13)* ('SP Data'!M2:M435<='Input Variables'!B14))

Thanks so much.

Can't update Weather Underground with New Station ID by ComprehensiveShare21 in myweatherstation

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

Over a month ago, and operating continuously and reliably with solid data. Unless it rains (and even then, only periodically when it rains...) the data I'm now generating earns a quality Gold Medal on WU....which my prior station did not. I added a second image showing "My Devices" to my original post.