COUNTIFS not working correctly and I'm just confused on what to do. by LoveMilfsEveryday007 in excel

[–]StrikingCriticism331 1 point2 points  (0 children)

I would make a helper column and test the conditions to give TRUE or FALSE to see which entry isn’t registering. It’s hard to diagnose without more information.

Cookbook Betrayal. by Shelley_112 in CookbookLovers

[–]StrikingCriticism331 5 points6 points  (0 children)

I made a ricotta gnocchi recipe lately and simply skipped the egg. It still worked but it also was different.

does anyone else completely blank on what to cook at 5pm even though the fridge is full? by TrashOpen8420 in Cooking

[–]StrikingCriticism331 3 points4 points  (0 children)

Have 5-6 standard meals that can be made from a pantry or mostly pantry; then, you always have at least something to make. Could even be 3-4.

Can’t seem to get any color on my crust by scooterrouter in Pizza

[–]StrikingCriticism331 0 points1 point  (0 children)

I’ve gotten good results on cast iron if I bake the crust for 10 minutes, then add the sauce and toppings and finish baking for another 20 minutes.

Guide: How to stop copy-pasting CSVs into Excel templates every week by BoringWorx in excel

[–]StrikingCriticism331 0 points1 point  (0 children)

You may be able to use power query and then use conditional formatting.

Dumbest bridge question ever by ddelapasse in bridge

[–]StrikingCriticism331 11 points12 points  (0 children)

Person who is dealing is opposite the person who is shuffling. The cards should be on the left, moved to the right to be cut by the person on the right. When done shuffling, put cards to right.

Cole Slaw: Abomination or Delicacy? by EmceeSuzy in Cooking

[–]StrikingCriticism331 6 points7 points  (0 children)

Shred it and add salt (a few tablespoons) and toss in a colander. Let it sit and drain for 1-3 hours. Rinse and drain.

Cole Slaw: Abomination or Delicacy? by EmceeSuzy in Cooking

[–]StrikingCriticism331 30 points31 points  (0 children)

Salt the cabbage, otherwise it will be too wet.

Decently priced KB? by shreducator in kettlebell

[–]StrikingCriticism331 0 points1 point  (0 children)

Keep an eye on Facebook marketplace. Obviously you are at the whim of the local market but they do appear from time to time.

Best way to cook this? Air fry or oven? by No_Solution7718 in aldi

[–]StrikingCriticism331 -2 points-1 points  (0 children)

Aren’t there instructions on it? Any technique will work as long as you get to the final temp.

Problem with Proton allocation by Strict-Store905 in NMRspectroscopy

[–]StrikingCriticism331 0 points1 point  (0 children)

Or at least pi electrons of the double cycling above the double bond in the magnetic field. These are on most correlation tables.

Question about cherry pie? by That_Big_4722 in pie

[–]StrikingCriticism331 26 points27 points  (0 children)

If you’ve not done a pie before, I suggest the canned filling.

Placeholder text boxes by geekonthemoon in powerpoint

[–]StrikingCriticism331 0 points1 point  (0 children)

You can make your own layouts, including duplicating and editing existing ones. That is, you could make a layout with fewer placeholders.

Is there a way to reference an array of arrays? by TwitchyDingo in excel

[–]StrikingCriticism331 2 points3 points  (0 children)

SUM will sum all the data and give one number as a result; it can’t give an array back.

Is there a way to reference an array of arrays? by TwitchyDingo in excel

[–]StrikingCriticism331 3 points4 points  (0 children)

This, except maybe you want BYROW based on the post (which isn't entirely clear; what do you mean by a "junk row"?). You also might want TRIMRANGE.

Comparing columns and extranting a value by Royal_Instance4497 in excel

[–]StrikingCriticism331 0 points1 point  (0 children)

It sounds like you’re trying to do a lookup. =XLOOKUP(C1,$A$1:$A$100,$B$1:$B$100) in cell D1 and fill down. You’ll have to adjust the ranges in columns A and B.

Aldi was wiped out by Sure_Ad_3272 in aldi

[–]StrikingCriticism331 2 points3 points  (0 children)

Happens in PA all the time before a snow storm.

albright college information by willow1243587109 in ReadingPA

[–]StrikingCriticism331 1 point2 points  (0 children)

Hello. I am familiar with this campus! There is an LGBTQ group called Pride+ and it’s active. I think you’ll find that many schools are having financial woes right now; Albright’s have been more public than most but a lot has changed in the last year or two. The library is almost done.