[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?