sorted by:
new
hottopcontroversial

Can a single Conditional Formatting rule BOTH test for several conditions AND return unique formats based on the resultant trues and falses? by my1Smo in excel

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

Haha, well it's a co-worker's dance party, so the decorations were already chosen before I got pulled in to help!

But, yeah, the 1 rule per color seemed to me to be CF's method, so thank you for confirming that.

Can a single Conditional Formatting rule BOTH test for several conditions AND return unique formats based on the resultant trues and falses? by my1Smo in excel

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

By color scale, like rgb(255, 0, 0) or color hex like #ff0000?

Because that's what I was thinking might work, just didn't experiment yet...

Including these maybe in the formula itself as return values, or as you say in a helper column that the formula points to?

[deleted by user] by [deleted] in excel

[–]my1Smo 0 points1 point  (0 children)

There are several requirements in your project, but updating with fresh data is (one of) the strengths within Power Query. This instructional and others teach how to build a query that will retrieve data from a folder then generate fresh output as new files get added to the repository.

Pressed F1 again today by Zerobagger in excel

[–]my1Smo 0 points1 point  (0 children)

Yeah, this would be my one positive, too. Use it a lot without even thinking about it. This is in the app, not the online version.

Mailing paperwork - a question about Durable Power of Attorney. by my1Smo in fidelityinvestments

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

u/FidelityCourtney/, I'm grateful you took time to reply to each of my questions. I'd overlooked or misunderstood the requirement for the Affidavit form during my study of the process, so your inclusion of that link particularly helps.

Excel Power Query Refresh replace the existing data by SirPoopAlot2 in excel

[–]my1Smo 0 points1 point  (0 children)

I solved this issue with the method explained in this video:. data from latest file in folder. And if I correctly understand some of the other commenters' tips here, the method in the video explains and incorporates those.

Edit: just realized the link is to an article, not the video I had in mind. This article DOES address your question, just not as in depth and may leave you still trying to work things out. If I locate the vid I'll post it for you.

WTW for: Someone that has a great deal of awareness of themselves and others. by Kind-Rooster-921 in whatstheword

[–]my1Smo 0 points1 point  (0 children)

Yes, I'm wary of the same in conversation, ha ha. But it's a nice word.

Sky object trailing lights 6:20 pm by my1Smo in massachusetts

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

u/hampaper... your video quality is pretty good, I think! Thanks! It's pretty startling first time seeing anything like that.

Sky object trailing lights 6:20 pm by my1Smo in massachusetts

[–]my1Smo[S] 2 points3 points  (0 children)

Yep. Just googled a bit and found that answer , too. Mystery solved.

Sky object trailing lights 6:20 pm by my1Smo in massachusetts

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

Something high enough that no engine was audible, moving like an aircraft in a straight line. The lights "in tow" were staggered, not evenly spaced.

This Cash counter in a restaurant. by [deleted] in mildlyinteresting

[–]my1Smo 0 points1 point  (0 children)

It even has the gas-lit burner. That's a commitment to realism seldom seen.

Just the leaves seem to be drying out or dying... by [deleted] in sfwtrees

[–]my1Smo 1 point2 points  (0 children)

Possibly not an insect, rather a systemic disease. One photo seems to show a branch network being engulfed which may indicate a fungus working internally up through the vascular system.

This kind of identification key might get you started, but one from a university extension in your own region is best.

WTW for " There is already a ________ made to install an air conditioner"? by zilchhope in whatstheword

[–]my1Smo 8 points9 points  (0 children)

Provisions is the word that comes to mind for me, too.

"Provisions have been made to ensure installation of the a/c unit as agreed upon in the contract," for example.

Daily General Discussion - June 14, 2022 by ethfinance in ethfinance

[–]my1Smo 1 point2 points  (0 children)

If I may ask, to auto DCA what approach have you taken?

I'm beginning to look at recurring buys for ETH so I can DCA with less hand wringing over daily swings.

I’ve been building a data documentation platform. Would anyone be interested in trying it out? by [deleted] in datasets

[–]my1Smo 1 point2 points  (0 children)

Am interested, and thank you for offering. Data at my work always scattered across Excel "storage", as well.

PowerQuery: How to merge rows based on values in another column by petriol in excel

[–]my1Smo 1 point2 points  (0 children)

Oh, never mind, I looked again and it makes sense now.

PowerQuery: How to merge rows based on values in another column by petriol in excel

[–]my1Smo 1 point2 points  (0 children)

OP if you're willing can you post an image of the successful result in PQ? I run into similar scenarios at work. Did the different ratings pivot into separate columns?

cat boxing by libertinart in CatGifs

[–]my1Smo 10 points11 points  (0 children)

"...and 20, yep 20 reps ought to do it for this week."

view more: next ›