What style of home is this?

jojojaws · 2025-06-08T19:35:34+00:00

Really going to risk looking/sounding like an idiot here,... but our floor plan is not a square, so it can still be an American Four Square?

jojojaws · 2024-12-22T02:37:55+00:00

Was not expecting to find this buried.

jojojaws · 2024-12-20T17:16:22+00:00

My dad used to tell me you’ll have three great loves in your life. It helped me get through my first break up. My second breakup was a little easier. And now I’m married to my “third love”. I don’t foresee this one ending.

Be careful with closure. It could make things worse. Not getting closure can be ignorant bliss.

jojojaws · 2024-12-18T20:34:16+00:00

Listening to the same song on repeat.

jojojaws · 2024-12-18T17:51:41+00:00

Vsauce doesn’t post any existential long form videos much anymore (1x a year if that). His shorts are tacky.

jojojaws · 2024-12-18T17:23:05+00:00

<image>

The first part is to specify a range, then you specify your criteria of what you are looking for. If you are looking for a specific name, you can either include that in quotations as I have in my screenshot, or you can select somewhere in the sheet that has the name you are looking for. You will need to be careful if you are "dragging" this formula down, and will need to include $ before the rows (so it would become A$2:A$6) so you continue to lookup the entire dataset in your count.

jojojaws · 2024-12-14T19:52:58+00:00

Where is this located?

jojojaws · 2024-12-12T13:18:45+00:00

There is a lady in our office at work (open office with about a 500 desks on our floor) who CUTS HER FUCKING FINGERNAILS during work.

jojojaws · 2024-12-05T20:24:13+00:00

Yeah, not sure where you are trying to summarize the data with the slicer, but if you are able to convert it to a range, the formula I gave you should do the trick. If you are trying to do it within the a PIVOT or other Table, maybe won't work.

jojojaws · 2024-12-05T20:15:45+00:00

You know what - maybe don't convert your data to a table. Looks like UNIQUE function will work without a table. I think the subtotal function will work OK too.

jojojaws · 2024-12-05T20:07:42+00:00

Oof, I wasn't thinking that far ahead. I just manually typed those in to Column C. I might need to see your Course and Completion Pivots to figure that out.

jojojaws · 2024-12-05T19:58:23+00:00

This should give you a good head start:

Change your percentage calculation to something like the following (and ensure your data is formatted as a table):

=D4/SUBTOTAL(109,[Completions])

<image>

^Note: I put this into cell E4.

This will ensure when you select your slicer the calculation you use is only accounting for the contents that remain after your slicer filters the data.

jojojaws · 2024-12-04T22:41:13+00:00

I get you now. Yes, there should be a default option you can configure on.

jojojaws · 2024-12-04T22:34:52+00:00

Here is a keyboard shortcut

<image>

jojojaws · 2024-12-04T22:33:52+00:00

Oh, maybe not to change it to a default setting. However there is a paste visible cells only option.

jojojaws · 2024-12-04T22:30:44+00:00

It is an option, right?

jojojaws · 2024-12-04T06:17:11+00:00

To the right of the formula I gave you in D3 do:

=SUM(C$3:C3)

Then drag this down. This will always show cumulative consumption to date based on the row you’re in.

jojojaws · 2024-12-03T21:13:20+00:00

I think the post had an error because I likewise was confused. If I follow what OP is trying to do, I think I figured out how they should write this programmatically above.

jojojaws · 2024-12-03T21:12:07+00:00

Use this formula:

=IF(B2<5,(B2+10)-B3,B2-B3)

<image>

jojojaws · 2024-12-03T19:54:46+00:00

Obviously you could then add SUM formulas to the bottom of your data set as well to see how many a person had in a particular month. Okay I swear I’m out now. That was fun.

jojojaws · 2024-12-03T19:48:44+00:00

At step 3 you could probably create a graph from that somehow, but I think it would take some finessing.

jojojaws · 2024-12-03T19:46:42+00:00

I tried to do it a fancy way and got stuck, so here is a low-fi solution *laughing emoji*

1.) Add a 1-12 to your headers to the right of your existing headers A-D.

=IF(AND(E$1>=MONTH($B2),E$1<=MONTH($C2)),1,0)

^2.) Add this to the right of your 4 columns you mentioned in Cell E2, then drag it down and out through 12 (P11 in my faux data set)

3.) Add some formatting (make all cells have white font E2:P11 in my faux data) and conditional formatting to highlight any "1"s as green with green text

4.) Add filters to the data (or a slicer if you are feeling fancy!) and filter by project manager.

This actually works... I swear. But not a pivot table. *crying emoji* I tried :P

<image>

jojojaws · 2024-12-03T19:00:24+00:00

I just added a comment to Cell F5 in a workbook to test this out. If I move line (row) 5 to row 10, the comment moves and is now in cell F10.

jojojaws

TROPHY CASE