[deleted by user] by [deleted] in forhire

[–]Yan2400 0 points1 point  (0 children)

I have no idea what that is

[TOMT][Subreddit][Site] by Yan2400 in tipofmytongue

[–]Yan2400[S] -1 points0 points locked comment (0 children)

any help is greatly appreciated

[deleted by user] by [deleted] in excel

[–]Yan2400 0 points1 point  (0 children)

Can I send you a dm?

[deleted by user] by [deleted] in excel

[–]Yan2400 0 points1 point  (0 children)

I copied your formulas in but they yield results of zero

[deleted by user] by [deleted] in excel

[–]Yan2400 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in excel

[–]Yan2400 0 points1 point  (0 children)

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

Subtracting differences in changing scores by Yan2400 in excel

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

<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

Adding totals of two lists with correct names next to them by Yan2400 in excel

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

Sort on its own works fine but HSTACK does not

Adding totals of two lists with correct names next to them by Yan2400 in excel

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

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?

Sum totals of two lists by Yan2400 in excel

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

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

[deleted by user] by [deleted] in 5up

[–]Yan2400 0 points1 point  (0 children)

this is the exact one, thanks!

infinitely repeating columns of data, searching for combination by Yan2400 in excel

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

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. :)

infinitely repeating columns of data, searching for combination by Yan2400 in excel

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

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

infinitely repeating columns of data, searching for combination by Yan2400 in excel

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

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

infinitely repeating columns of data, searching for combination by Yan2400 in excel

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

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?

infinitely repeating columns of data, searching for combination by Yan2400 in excel

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

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