sudojay

For my work, I have to do a lot of concatenation of values based on specific conditions. One tool that's been invaluable has been an array formula with TEXTJOIN, e.g. {=TEXTJOIN(",",TRUE,IF(A3:A11=C4,B3:B11,""))}

I generally get results like this, with the bottom three rows being the results of the formula

1 a

1 b

2 c

2 d

3 e

3 f

1 a,b

2 c,d

3 e,f

I just got a new computer for work and the array won't work. Is there a setting in Excel I need to change?

Excel Office 365

One thing that drove me a little crazy about the subreddit-whose-name-I-don't-want-to-speak is the attitude that if there was a link in the FAQ/Wiki, you couldn't ask the same question. There are several issues I had with that.

1. Often the information in the previous linked posts was outdated.
2. Users who didn't see the original post linked in the FAQ might have very different answers.
3. Users who posted on the old posts may not be active and available for further discussion.
4. It made the sub (and every sub that has this policy) incredibly unfriendly. Filter out posts you don't want to see or just don't open them.
5. The information in the links is not in the most useful format. Going

There are two things I notice with the game that I think could be improved.

First, you only get to practice throwing pokeballs when you have a pokemon you're trying to catch. It's not a huge deal but it could be nice if you could practice the timing to get excellent curveballs and just in general, there are ways you could have a fun practice mini-game.

Second, getting enough coins to get anything of value without paying real money is pretty difficult. I know Niantic wants to make money but it can be disheartening when there are folks spending money on incubators and lucky eggs to get ahead and you can't. I'm an adult with a real job so if I want those things, I can get them. If I were yo

For the first time, at least the first time I've noticed, I received a "This pokemon is too far away" message when tapping on a Pidgey sitting right next to me. I wish I'd take a screenshot now but it was a message just like the one you get when it says a pokestop is too far away but I was definitely tapping a pokemon and it definitely said "This Pokemon is too far away". Had anyone else noticed this? Is this a new "feature"?

I've just started doing some pretty basic videos for projects at work. It's turned out to be very effective for getting attention to projects that otherwise would languish. I'd love to do more ambitious editing but my work computer struggles with even pretty minimal video editing software. I'm happy to put out some cash on a good rig for editing both for work and personal projects. The only results I find for advice on hardware are a couple years old. Does anybody have advice on good computer rigs from the selection currently available?

Thanks in Advance

I apologize if this is pretty basic. I am an advanced beginner in SQL (at best) and need to perform queries on a massive database at work on a regular basis. All of the tables are huge so often queries to pull the data I need are so big they timeout before I get anything. I can get around it by delimiting what I want to a smaller subset for each query but it's a bit infeasible for me to keep going back to put the query in. Is there a way that I can set up a query queue to pull each smaller section of data in succession? Thanks in advance!

Like the title says, the traffic lights are out and it's having a serious effect on traffic so avoid it if you can. I'm baffled as to why there isn't a police officer out directing traffic.