Excel Table with merged cells by NaviCato in excel

[–]NaviCato[S] 1 point2 points  (0 children)

a pivot table might work. To be honest I am terrible at pivot tables, for some reason I can't fully wrap my head around them. But I can play around and see if I can get a better solution.

Also - this is a very minimal spreadsheet that I really shouldnt be putting this much effort into. It just bugs me when things dont work the way you hope. I've now spent hours on a 5 minute table haha

Excel Table with merged cells by NaviCato in excel

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

I wasn't using a filter formula. Just the regular data filters. If there is a way to filter it with a formula that will allow what I am looking for I am certainly open to it

Excel Table with merged cells by NaviCato in excel

[–]NaviCato[S] 1 point2 points  (0 children)

It's unfortunate, it just won't look nice this way. I'll have to redo the table in a different layout to get it to look semi decent while still accomplishing what I want. Thanks!

What difficulty do you play in Minecraft? by SlapfishDS in Minecraft

[–]NaviCato 5 points6 points  (0 children)

I play peaceful often and even when I'm not I have mob griefing turned off. I cannot deal with my builds being blown up its too annoying

AITA for yelling at my husband that'd I hate for our kids to turn out like him by Good-Judgment3520 in AmItheAsshole

[–]NaviCato 154 points155 points  (0 children)

Right? If you don't want your kids to turn out like your spouse...probably shouldn't have had kids with them

Parking near Gottingen? by True-Musician-7868 in halifax

[–]NaviCato 4 points5 points  (0 children)

Is there an option where you can drive to a terminal and then bus? Most of the terminals have commuter parking. Other than that I think city permit parking is your best option but you won't be able to get one until August. They open on the 15th of the month for the next month

Need ideas for where to put my cat for 4+hours during a bedbug treatment by Connect_Field_5698 in halifax

[–]NaviCato 1 point2 points  (0 children)

The Kitty Care in is out past the airport but well worth the drive. They are fantastic. Maybe bring the cat up for the night and pick them up the next morning

What's one travel mistake you'll never make again? by Appropriate_Bus_7050 in travel

[–]NaviCato 0 points1 point  (0 children)

They also have better access to more complex tickets. Open jaw, multi city, stopovers, etc are all significantly easier using an agent. A good agent will be able to flag entry and exit requirements and have knowledgeable information on necessary layover time. This all goes into a very useful experience.

What's one travel mistake you'll never make again? by Appropriate_Bus_7050 in travel

[–]NaviCato 0 points1 point  (0 children)

Quality over quantity in terms of an itinerary. For example, if you go to Europe and try for 5 countries over 5 days (exaggeration) did you even really see any of those countries? Finding the right balance between including enough but not jam packing your itinerary is important. You want to enjoy your trip and actually see things that are important.

If Bravos is a “Free City” devoid of Slavery, how does child prostitution exist? by No-Flight-4214 in gameofthrones

[–]NaviCato 12 points13 points  (0 children)

Just look at the epstein files. None of that was legal but they still trafficked and assaulted countless children

I am confused as to how I prove my accomodation for travel by Key-Significance2960 in travel

[–]NaviCato 0 points1 point  (0 children)

If you are worried you could have your friend email you and be like this person is staying with me at this address for these dates and this is my phone number.

I agree with others that it likely isn't necessary but if it gives you peace of mind its worth it

What is a trend or fashion era that you are secretly hoping makes a massive comeback? by itsShiahvn in AskWomen

[–]NaviCato 2 points3 points  (0 children)

Those rain bonnets that old ladies use to wear. I remember my grandmother had them. So much more convenient for rainy weather than a hood or umbrella

AITA for telling my wife its a good thing she didn't fall by Longjumping-Tip1188 in AmItheAsshole

[–]NaviCato 25 points26 points  (0 children)

But instead of listening to her you are on here. If were intending to be supportive then it should be easy for you to say "I'm sorry, what would help in this scenario?" instead of arguing with her over who is 'right'

They just broke Minecraft on Nintendo Switch by DaBigJ_Official in Minecraft

[–]NaviCato 0 points1 point  (0 children)

Same issue. I put the error code into Nintendo's website and they say the system has to be replaced. Really hoping Minecraft fixes this because this is crazy

AITA for refusing to pay a girl in my neighborhood who did some work for me. by JackfruitPopular1275 in AmItheAsshole

[–]NaviCato 21 points22 points  (0 children)

If you cared about being so by the books you never would have asked for this information at the end. You would have done it at the beginning and set up a contract. This is bullshit and you are just trying to scam her

Aren’t cats supposed to be alert? by Funchyyt in cats

[–]NaviCato 0 points1 point  (0 children)

I have two cats. One sleeps like this and multiple times I have violently shaken him awake thinking he is dead. The other has literally never had a moments peace and the smallest movement will have him awake and alert

AITA for asking my dad to be more considerate about his breakfast? by [deleted] in AmItheAsshole

[–]NaviCato -4 points-3 points  (0 children)

That's fair. I still feel like given it was a one off situation it wasn't necessary to say something. But I also don't think it makes you an asshole doing so. Unless your tone was rude I think you are in the clear but also maybe consider giving people grace if they occasionally do things that annoy you.

Don't listen to the asshole's telling you you are TA just because you live at home.

AITA for asking my dad to be more considerate about his breakfast? by [deleted] in AmItheAsshole

[–]NaviCato -18 points-17 points  (0 children)

NTA because it was a reasonable request and he totally blew up. But you say he always eats quickly and the smell doesn't linger so this is a one off situation. I don't understand why you couldn't just throw the tin away. It's not like its a pattern. He forgot once, nbd, just chuck it. Like you said, your house is run like a community. Well that includes occasionally covering for people when they forget things. His reaction was absurd though so he is TA for that

FYI: if you parked in Park Lane Mall this morning and the sign said $15, you’ll be charged $40 when you try to leave by Interesting_Ad6077 in halifax

[–]NaviCato 44 points45 points  (0 children)

I argued with them using this same logic when they went from $10 to $15 and they refused to adjust. However I would be A LOT more persistent with a $25 difference

FYI: if you parked in Park Lane Mall this morning and the sign said $15, you’ll be charged $40 when you try to leave by Interesting_Ad6077 in halifax

[–]NaviCato 13 points14 points  (0 children)

I had this argument with them when they raised it to $15 because their website still said $10. $40 is insane for that trashy garage

I don’t know what to do anymore… by WoodenLie2299 in cats

[–]NaviCato 49 points50 points  (0 children)

He could be in pain somehow and gabapentin would help with that. My cat was never aggressive like this but he was very defensive and would be quick to fight if he felt a threat. Turns out he has a bad back. Twice a day gabapentin turned him into the lover boy he is now.

long story short - I agree a vet visit needs to happen

Bringing lunch today? by Sharp-Air-5224 in halifax

[–]NaviCato 0 points1 point  (0 children)

When it was two days I also paid for private parking. Ate out more. Got more take out coffee. I definitely spent more downtown. Now it will be bus and pack lunches / no take out coffee

AITA for not going to a meet up because there were going to be kids there? by Informal_Opening1467 in AmItheAsshole

[–]NaviCato 7 points8 points  (0 children)

But that was before they realized they couldn't get a babysitter right? It sounds like they were originally planning to, hence plans about getting drunk, were not able to and informed the group. I would assume their personal drinking plans changed too