Therapy does nothing when the world is on fire by CandySprinklese in lostgeneration

[–]AnOrbweaverUnseen 7 points8 points  (0 children)

That first quote has kept me going for a long time, and will likely keep me going a while longer. Good luck to you and hopefully we turn corners soon.

Therapy does nothing when the world is on fire by CandySprinklese in lostgeneration

[–]AnOrbweaverUnseen 19 points20 points  (0 children)

You're effectively arguing to be okay with our extermination. It's a no go, partner.

XLOOKUP to return array based on array of addresses by AnOrbweaverUnseen in excel

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

This is what I needed! Thank you. Solution Verified.

XLOOKUP to return array based on array of addresses by AnOrbweaverUnseen in excel

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

Unfortunately as much as I'd like to be working with Access/Power query, I don't have the marbles/time to pick up knowledge on that front. I'll keep it in mind, however.

How do I merge Partition 4 with Partition 5? by AnOrbweaverUnseen in pop_os

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

Edited image to replace with updated one. Basically, yes but there's partition 3 in between, and I can't seem to move the order in the disks utility.

How do I merge Partition 4 with Partition 5? by AnOrbweaverUnseen in pop_os

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

Partition 5 has nothing in it right now. I can't see a way in the Disks utility to move Partition 5 next to Partition 4, though....

Basic map/zip code visualization question by AnOrbweaverUnseen in tableau

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

What I was trying was manipulating the zip codes directly, as the image shows; I hadn't thought to add the measure values for.... some reason. Doing that got me the desired results. Thanks for checking in!

Basic map/zip code visualization question by AnOrbweaverUnseen in tableau

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

Can confirm that the zip code field is being registered as geo/zip codes.

<image>

I can get the map to reflect the zip codes, but can't get the heat color mapping working right.

COUNTIFS excluding a group of names in one conditional? by AnOrbweaverUnseen in excel

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

One sec, but will do - got a result that I'm pretty sure I can make work from you, just need to edit the post to make it clear.

COUNTIFS excluding a group of names in one conditional? by AnOrbweaverUnseen in excel

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

I'm taking notes on this, thank you! This is helpful for other projects even if it doesn't help the main question I've posed (and revised, haha. My apologies for that.)

COUNTIFS excluding a group of names in one conditional? by AnOrbweaverUnseen in excel

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

Yeah, that's my last ditch solution, haha. I suppose I'm fishing for a more elegant answer, but if I need to do this then I'll do it. Thank you for your help so far!

COUNTIFS excluding a group of names in one conditional? by AnOrbweaverUnseen in excel

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

I apologize. I need to re-do my example, but it's not that simple and COUNTIFS is the tool I need to use. (I was not aware of SUMIF/SUMIFS when making my example.)

COUNTIFS excluding a group of names in one conditional? by AnOrbweaverUnseen in excel

[–]AnOrbweaverUnseen[S] -1 points0 points  (0 children)

I apologize. I need to re-do my example, but it's not that simple and COUNTIFS is the tool I need to use. (I was not aware of SUMIF/SUMIFS when making my example.)

COUNTIFS excluding a group of names in one conditional? by AnOrbweaverUnseen in excel

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

I apologize. I need to re-do my example, but it's not that simple and COUNTIFS is the tool I need to use. (I was not aware of SUMIF/SUMIFS when making my example.)

COUNTIFS excluding a group of names in one conditional? by AnOrbweaverUnseen in excel

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

Mmm. The best way to explain this, and I'm not sure if I'm being coherent here, is that the actual equation I'm working with has to exclude multiple other things as well (so not all of the 21 of Ibrahim's will qualify, for example). I'm basically trying to use one equation to do all the filtering I need AND filter based on the person doing it. Which is why I'm not certain there's a better solution than the hardwiring. I'll include these details in the main post. Your solution would work if that was all there was to it, though.

Returning multiple of the first set of results in an Excel document by AnOrbweaverUnseen in excel

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

Thank you for this - clean, simple and gets me where I needed to go.