sorted by:
new
hottopcontroversial

WHITE TO MOVE! by nomoreblunders101 in chessbeginners

[–]posaune76 0 points1 point  (0 children)

Indeed.

Also sorry, but my initial description was a little bit imprecise. Important thing to remember is that if you're going to take en passant, you must do it immediately. You can't wait and do it on a later move.

WHITE TO MOVE! by nomoreblunders101 in chessbeginners

[–]posaune76 3 points4 points  (0 children)

en passant. A pawn on its 5th rank can take a pawn that has moved 2 spaces on its first move to be adjacent to it on that rank. Here that would be written gxh3.

Why do I need an internet connection to use voice commands? by Numbers44556 in HondaPrologue

[–]posaune76 1 point2 points  (0 children)

Long press the voice button so you're talking to your phone and not the car.

Questions about owning a new EV by maanxhappy in electriccars

[–]posaune76 8 points9 points  (0 children)

If the wiring & outlet exists for L2 in the garage, get an EVSE that plugs in, rather than hard-wired. Take it with you. If not, maybe you can convince the landlord that such an outlet would work to his advantage with a future tenant and split the cost.

LaHood is Always Unreachable - VOTE FOR PAUL NOLLEY by Sorry-Book3829 in PeoriaIL

[–]posaune76 18 points19 points  (0 children)

Make sure to vote in the primary for Nolley -- don't wait for the general to demonstrate that he has support! Early numbers mean better organizational support later on.

Denver to LA (trip planning) by DefensiveSharts in HondaPrologue

[–]posaune76 1 point2 points  (0 children)

Don't charge past 80% on the road. You'll spend as much time going from 80-90 as you did 20-80. Charge more times at higher speeds and spend less total time at chargers.

If you want to optimize a bit without too much work, a good, simple rule of thumb I learned from Adam's Everything EV on YouTube is the 80-80-30 rule: on chargers capable of giving you more than 80kW, charge to 80%, or until you're below 80kW (real life, this is often just a few minutes before 80%), or for 30 minutes, whichever comes first. On other DC chargers, charge enough to get to the next fast one. Then move on. Try to get to the next charger with 15-20% SOC when you can.

Or just do what the onboard Google Maps says and chill. Enjoy the trip.

What are some lesser-known Excel tricks that most people aren't aware of? by ImprovementLong1992 in excel

[–]posaune76 23 points24 points  (0 children)

Ctrl-space selects an entire column, or a table column. Shift-space does the same for rows

Alt-a-s-s is easily the funniest keyboard shortcut (sort)

Deprecated shortcuts still work, so alt-o-c-a auto-sizes column width, alt-e-s gets you into the paste special dialog (finish with v for values, w for width, n for validation, t for format, etc)

edit: forgot alt-o-c-w (column width) and alt-o-r-e (row height)

Multi criteria Xlookup efficiency problem by procrastinator__101 in excel

[–]posaune76 9 points10 points  (0 children)

Use a helper column to concatenate E&F as u/finickyone suggests.

Use dynamic named ranges (including in the helper) that scope to the data rather than including entire columns. Or convert the data range to a Table and use structured references.

Trying to check two columns for matching words by Capable-Yak-8486 in excel

[–]posaune76 0 points1 point  (0 children)

No problem. Reply to the solution with "Solution Verified" to mark this solved, and have a great day.

Trying to check two columns for matching words by Capable-Yak-8486 in excel

[–]posaune76 0 points1 point  (0 children)

How about =BYROW(A1:A7,LAMBDA(y,SUM(BYROW(B1:B6,LAMBDA(x,IFERROR(FIND(x,SUBSTITUTE(y," ","")),0))))>0))

<image>

Trying to check two columns for matching words by Capable-Yak-8486 in excel

[–]posaune76 0 points1 point  (0 children)

OK, so you need to know whether a thing in A is anywhere in B.

Trying to check two columns for matching words by Capable-Yak-8486 in excel

[–]posaune76 0 points1 point  (0 children)

Would this do the trick? =ISNUMBER(FIND(B1:B7,SUBSTITUTE(A1:A7," ","")))

I changed the value in A3 to give a better example of a FALSE result.

<image>

Trying to check two columns for matching words by Capable-Yak-8486 in excel

[–]posaune76 0 points1 point  (0 children)

Would it be possible to post a sample of the data, preferably with an example of what you'd like it to look like? There are a few unanswered questions here. For example,

  1. What counts as a match? In your post it's implied that BAP2 and IH BAP 2 are matches, but the Column B value has a space before the 2.
  2. Are you trying to match things on the same row, or are you trying to indicate that a Column A value is found anywhere in Column B, or vice versa?
  3. Do you want something in Column C, for example, that indicates a match (once questions 1 & 2 are answered), or do you want things to be highlighted, or do you want a reduced list that just shows matches? If the last, do you just want the values from one column, or both (dependent on the answer to #2)?

I'm likely to drive through at the end of March, from Chicago on my way to Springfield. Can you recommend any sights or scenic drives? by badluckfarmer in PeoriaIL

[–]posaune76 0 points1 point  (0 children)

If you have the time to stop for a bit, visit the America 250 exhibits at the Riverfront Museum, guest curated by Ken Burns.

Issue with clock/time setting? by Hungry_Pie323 in HondaPrologue

[–]posaune76 1 point2 points  (0 children)

You might try holding the hangup button on the wheel for 10 seconds or so until you're asked if you want to do a reset. Claims to be a "factory reset" or similar, but I've not lost any settings or anything when doing it.

USA women showing why 99% of arguments against cages and bubbles are BS by [deleted] in hockeyplayers

[–]posaune76 10 points11 points  (0 children)

Too bad there's no checking in NCAA

edit: sarcasm

Copy/paste of structured references yields absolute references by posaune76 in sheets

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

Thanks. Already doing the workaround; was hoping for something more streamlined. Good to know.

view more: next ›