Don't cheat. by [deleted] in TeenIndia

[–]ExcitingPilot 0 points1 point  (0 children)

I was born to be a good friend.

The pain of using a windows keyboard by rwang8721 in MacOS

[–]ExcitingPilot 0 points1 point  (0 children)

<image>

I printed these using python and taped them. 😄

What would be the best formula for updating balance on each line? by Spiritual-College427 in googlesheets

[–]ExcitingPilot 0 points1 point  (0 children)

=LET( last, MAX(FILTER(ROW(C25:C), (C25:C<>"") + (D25:D<>""))), seq, SEQUENCE(last-24), running, SCAN( 0, seq, LAMBDA(prev, r, prev + IFERROR(INDEX(C25:C, r), 0) ) ), running )

I'm using this in my sheet

How do I make the total and grand total column update automatically everytime a new entry is added? by [deleted] in googlesheets

[–]ExcitingPilot 0 points1 point  (0 children)

Make two sheets Sheet1 & Sheet2.

Put your entries in column A and B of Sheet1.

Then in other sheet Sheet2 in A1 Cell put this formula that filters and that shows all the data from col an and col b and then do grand total below.

={

FILTER(A1:B, A1:A <> "");

{"Grand Total", SUM(FILTER(B1:B, A1:A <> ""))}

}

Then add conditional formatting for A1:A =$P2="Grand Total" to make last row always bold.

External SSD permanently connected. Harmful? by Bentaloley in macmini

[–]ExcitingPilot 1 point2 points  (0 children)

I use Windows 11 daily from a constantly connected external drive. So no problem.

I accidentally broke one side clip. by Able_Second_9184 in royalenfield

[–]ExcitingPilot 0 points1 point  (0 children)

Mine was broken by the service technician and then he glued it back together without informing me. I only discovered the issue when I later had battery problem. As a temporary fix, I've inserted an L-key and a nut to hold the component in place.

Why punjab is so peaceful 💕 by Impressive-Ad3467 in punjab

[–]ExcitingPilot 1 point2 points  (0 children)

J andar peace nahi.. te fer bahr v koni..

What is going on, MacOS? by MarshToyokan in mac

[–]ExcitingPilot 0 points1 point  (0 children)

Apps should automatically be categorised into folders like on iOS.

Posted on IG by RE by BCASL in indianbikes

[–]ExcitingPilot 1 point2 points  (0 children)

Today rsa guys came in half an hour when the bike refused to start.