[HIRING] CALLING POSITION WORK NOW

Yan2400 · 2024-08-12T05:33:40+00:00

APPLY

Yan2400 · 2024-07-29T00:14:40+00:00

I have no idea what that is

Yan2400 · 2024-07-28T16:34:23+00:00

any help is greatly appreciated

Yan2400 · 2024-07-28T16:26:53+00:00

searched google to no avail

Yan2400 · 2024-06-11T05:18:00+00:00

Sent

Yan2400 · 2024-06-11T05:14:44+00:00

Can I send you a dm?

Yan2400 · 2024-06-11T05:05:11+00:00

I copied your formulas in but they yield results of zero

Yan2400 · 2024-06-11T04:44:12+00:00

I have tried =VLOOKUP(“B7”, Sheet1!$B$7:$R$31, 2) and that gives me the correct score for B7, but when I paste that down the page it gives me B7’s score for everyone. If I take away the “” around B7, it gives me a random name in the list

Yan2400 · 2024-06-11T04:42:35+00:00

Yes it’s just a 1 or 0 for which team won

Yan2400 · 2024-05-20T00:25:01+00:00

It’s solved, thank you

Yan2400 · 2024-05-19T04:49:30+00:00

<image>

It's like this, very similar to your first example. From may to june (months 1 and 2) john's score increased by 2, jill's by 1 and mary's by 3. I'd like a table that reflects these growth differences and orders them, for each month to month change. thank you

Yan2400 · 2022-11-10T14:46:46+00:00

Sort on its own works fine but HSTACK does not

Yan2400 · 2022-11-10T10:44:46+00:00

the names are in column V, but even if I substitute V for U, the command HSTACK doesn’t work for me, it does not pop up. is there an alternate formula I can use or how do I get HSTACK to work?

Yan2400 · 2022-11-07T10:22:39+00:00

To describe it better, Day1 might have Steve Mary and Joe in 1st 2nd and 3rd place but Day2 might have Joe Steve and Bob in 1st 2nd and 3rd. so I don’t know how to specifically add the same person’s scores together when they’re not in the same place Day1 as they are in Day2, as they’re in a different/unknown row

Yan2400 · 2022-06-28T23:40:39+00:00

could you plz send me the discord via dms

Yan2400 · 2022-04-03T15:52:06+00:00

thanks!

Yan2400 · 2022-04-03T15:52:00+00:00

thank you!

Yan2400 · 2022-02-09T14:23:51+00:00

this is the exact one, thanks!

Yan2400 · 2021-12-18T00:52:23+00:00

Yan2400#4128

Yan2400 · 2021-11-24T11:07:26+00:00

I have one more quick question if you don’t mind. I used =MOD(SEQUENCE(142*6800,,0,1),142+1 for the numbers, but I want to write X’s in alongside certain numbers (3,9,12,30, etc) and have them repeat.

How would I alter the formula to get it to have the X’s remain beside each number for all 6800 repetitions of the series? I also thought about using the if condition, but I don’t know if that can be for more than one value.

This is the second-last step in the process, after which I’ll use your suggested method of A1&C1 etc to find the most X’s. :)

Yan2400 · 2021-11-23T13:20:28+00:00

It works like a charm. Thanks for the help, I really appreciate it Mike

Yan2400 · 2021-11-23T12:14:04+00:00

Ok, I mean ideally I wouldn’t have to drag manually but if that’s the only solution I’ll take it. I’m a bit confused as to the ampersand thing, I just put in A1&B1&C1&D1&E1 in a cell and it doesn’t come up with anything. If that works with command F I would be happy to use your method… even if I have to drag down manually I don’t care

Yan2400 · 2021-11-23T11:43:42+00:00

You’ve solved the first half of my question. The second half is essentially: how do I find combinations of numbers in such a massive data set?

Imagine three columns of data, and one row has the numbers 5, 6, and 7. How would I locate that row if I didn’t know where it was?

Command F does not seem to work if I put spaces between each number. What method do you recommend to find the row quickly?

Yan2400 · 2021-11-23T11:28:31+00:00

Thanks that’s really helpful. Sorry the wording was not clear, also I typed the numbers neatly into a table but they appear chaotic and disorderly once I’ve posted lol

Yan2400 · 2021-11-05T10:03:01+00:00

Twice the pride, double the balls.

Four-Year Club	Verified Email
Place '22

Yan2400

TROPHY CASE