u/_lostcrow — reddlx

I feel dumb for not being able to dock my switch 2

I recently got a switch 2 from my sister’s ex-boyfriend after their breakup and it is not sitting on its dock properly. I have been trying to dock it for 15+ minutes but it just doesn’t want to sit or charge in its proper place and just slides around, I hope he didn’t break it. It does still charge normally and is able to turn on. Please help.

EDIT: The part where the switch actually clicks into seems to be wobbly and gets crooked

Edit edit: WE FIGURED IT OUT, ITS JUST SILLY AND NEEDS A CERTAIN ANGLE

u/_lostcrow — 1 day ago

▲ 3 r/excel

How to use IF function in a helper column

Okay, so this is a continuation of my previous post (https://www.reddit.com/r/excel/comments/1u8hkbo/populating\_a\_table\_based\_off\_of\_values\_over\_a/) but now I have the FILTER running and working, it's now just the dates and times from the merged cells not transfering over. I don't really understand how to the helper column works but this has been my best attempt so far. I have tried many different things with the helper column but it keeps giving me zeros or gives me an error that it is trying to do a circular reference. Any guidance on that?

https://preview.redd.it/uj81ka85ow7h1.png?width=1885&format=png&auto=webp&s=f366dba3207921b2e4997f885475a19e4401d7b4

reddit.com

u/_lostcrow — 19 days ago

▲ 9 r/excel

Populating a table based off of values over a certain number

I am doing some research and I have a bunch of data that I want to create a smaller table with. I would like to be able to make a table that only has the information of data points with a Confidence Level equal or greater than 0.95. What sort of functions should I use? I have tried =FILTER but I don't know if I used it correctly. Thank you in advance for any help, there is over 1300 data points that I would have to manually sift through otherwise to accomplish this. I would also like for the Date and Time to stay with the individual values as well if that is at all possible with the merged cells.

https://preview.redd.it/j7x3ls8vsv7h1.png?width=892&format=png&auto=webp&s=2da5b32693f68d68785c633414baf8560c9ab4b7

reddit.com

u/_lostcrow — 19 days ago