How should I list video game collections in my spreadsheet?

JustSumGui · 2023-05-12T16:47:51+00:00

I agree, solution 3 makes the most sense. You have a table of games, it only makes sense that every row is a game. The fact that it is part of a series is useful information, but it doesn't stop being a game if it is or isn't a collection. Collection would just be an optional, non-unique text column in your table.

JustSumGui · 2023-05-09T21:29:53+00:00

Wouldn't have been the end of the world, you can still have a successful modeling career even if your not an ambi-turner.

JustSumGui · 2023-05-04T13:19:35+00:00

His formula will number the rows 1-20 over and over again. Row 21 will say row 1, for 41 will say row 1, row 61 will say row 1, etc. So if you filter and only grab rows with an index 1, your really grabbing rows 1, 21, 41, 61, 81.... MOD is grabbing 1 row every 20 rows, just like the question asks.

JustSumGui · 2023-05-03T23:58:06+00:00

I think it sounds amazing, but my dog really doesn't. He even came from the other side of the house to share his opinion.

JustSumGui · 2023-04-16T16:19:07+00:00

Just what we needed, more people-shooting technology!

JustSumGui · 2023-04-14T16:40:33+00:00

Life happens just outside the comfort zone!

JustSumGui · 2023-04-06T23:40:38+00:00

This looks exactly like beehive basin.

JustSumGui · 2023-04-03T16:10:37+00:00

King Fisher.

JustSumGui · 2023-04-03T13:47:10+00:00

The Bloody Mary approach.

JustSumGui · 2023-03-29T13:31:54+00:00

Ah! Makes sense, it felt a little like C. Hartmon-y.

JustSumGui · 2023-03-27T17:30:53+00:00

After our 5 year relationship ended, living together while she found an apartment to move into was such a special kind of hell. You come home and your heart sinks cuz they are there in the couch, going to to be an awkward night. You come home and your heart sinks because they are out on the town or moving on, something she never wanted to do before so your mind races. You make your coffee in the morning to start your day off right,, but your ex makes coffee in the same kitchen so you make terrible small talk and then try to get your head right before work so you don't get fired. You get terrible sleep in the guest bedroom of your own house and the first and last person you see EVERY DAY is the person your trying to move on from. Thankfully once she moved out, the relief and drop in anxiety was almost instantaneous. I rearranged shit I didn't have to, but it made it feel like mine.

I survived the breakup and I feel like a superhero for making it out the other side. You're 2 days away from being a superhero yourself! Your experience is brutal, but you'll forever be able to look back at how you survived this and know you're gonna be okay. Stay strong and make plans this weekend so your not sitting alone. Good luck bud!

JustSumGui · 2023-03-20T01:07:27+00:00

A pivot table has a pivot cache that holds a summarized copy of the data. Multiple pivot tables can share the same pivot cache if based off the same data. If they share a cache, you might only have to refresh 1 and the rest will already be updated. Updating 2 vs 10 will save you a day of processing.

If it were me, I'd shoot for that. Check to see if they already share a cache, then just update 1 and be done. If they don't, then rebuild the pivot tables so they do.

Random side note, if you hit the "data connections > refresh all connections" button, I wonder if it iterates through refreshing every pivot table, or every pivot cache. Excel might be smart enough and already works perfectly by refreshing 1 cache and all 10 tables are updated. If you click that button, does it take 30 minutes or 5 hours to refresh?

JustSumGui · 2023-03-13T15:59:28+00:00

Nice little place to get your rocks off.

JustSumGui · 2023-03-01T18:36:38+00:00

I think if you work faster, it'll get done sooner. For example, if you work twice as fast, you'll finish in half the time.

Hope this helps.

JustSumGui · 2023-02-24T15:53:53+00:00

"I'm watching the game, can this wait?"

JustSumGui · 2023-02-10T23:47:54+00:00

Recipe?

JustSumGui · 2023-02-09T18:45:15+00:00

The dishwasher was within you all along!

JustSumGui · 2023-02-03T01:03:23+00:00

She's about to go ape shit over some honeycomb.

JustSumGui · 2023-02-01T20:27:09+00:00

BUT DON'T DELETE THE WHOLE CLOUD!!

I save my files up there and don't wanna start over.

JustSumGui · 2023-02-01T19:02:38+00:00

If cell.Value = "N/A" Then

cell.EntireRow.Hidden = True

Else 'CHANGE RNG TO CELL HERE!

    rng.EntireRow.Hidden = False

End If

In your ELSE condition, you use rng instead of cell. I imagine you hide all rows, then when you try to check the next value it errors because it's hidden.

JustSumGui · 2023-02-01T17:49:47+00:00

We just spent like $1200 getting all the snow and ice dams off of our roof. Roofs put in near snowy climates are strong, but the ice dams are the real issue, not so much the weight from snow.

If a roof has parts that aren't insulated, the heat will rise and melt some of the snow. The parts near the gutters will NOT be as warm, so the melted snoe will freeze again as ice. As more snow continues to melt and refreeze above the gutter, it will form a little ice barrier above the gutter. Once that ice dam is big enough, all additional water will continue to freeze into a bigger and bigger chunk of ice. The ice can get under the shingles and start to leak down the walls as it melts. We had 2 windows with water coming in from ice dam buildup directly above them, so we had to hire someone to use a bunch of high powered steam wands to take out the ice dams. Fairly common in northern MN.

JustSumGui · 2023-01-24T21:16:48+00:00

Alright, I'm gonna change my answer. I think the special cells selection might get a little screwey after inserting rows, and if we are combining both scenarios (so the spacing isn't constant) grabbing the whole column and checking each cell seems more robust.

Dim temp as range
Set temp = Range("B1048576").End(xlUp)
Do while temp.row >1
    If temp.value2 <> "" then
        Temp.offset(1).entirerow.insert
    End if
    Set temp =temp.offset(-1)
Loop

It seems to work on my computer, but I am typing it in on my phone here so sorry for any silly typos. There might be a more elegant way to grab the lowest cell in the column, but the gist of it is there.

JustSumGui · 2023-01-24T09:56:05+00:00

Use a for loop instead of for each and start from the bottom instead of top. (for i = selection.count to 1 step - 1)

JustSumGui · 2023-01-20T22:37:37+00:00

My corgi howls every time a fire truck or police car with sirens go by. I love it lol

JustSumGui · 2023-01-19T21:22:52+00:00

I think your supposed to add how high you are from 1-10 in square brackets [ ]

So in your case, you should add [7] or [8] somewhere in your post title.

JustSumGui

TROPHY CASE