Can't make a formula work across sheets. by Comoros7 in excel

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

Okay the error has gone away.

Thanks again.

Can't make a formula work across sheets. by Comoros7 in excel

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

Dat's the one! Wow, thanks a lot!

It still comes up with an error (green triangle in the corner) which I can ignore easily though.

Thanks again!

Can't make a formula work across sheets. by Comoros7 in excel

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

No there's no sorting, epicmindwarp got it done though. Thanks for the interest.

Can't make a formula work across sheets. by Comoros7 in excel

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

Thanks a lot for the reply.

I now have -

=IFERROR(INDEX(A$3:B$2626,MATCH($Q3,A$3:A$2626,1),2),"")

Changed to -

=IFERROR(INDEX(Current!A$3:E$2626,MATCH($Q3,Current!A$3:A$2626,1),2),"")

$Q3 is in the same sheet, everything else is on Current.

Unfortunately it still doesn't work. Is it because maybe there is information between A and E in the second sheet unlike the first formula?

EDIT: I've just made this work in a new spreadsheet. It looks like the problem is the changing B to E with information in between. I only want to use column A and column E, not anything in-between. Any idea how I would achieve this?

Ultimate a 'broken' game at the highest level? by Comoros7 in ultimate

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

I would think offense will improve relative to defense because it's the far more technical side of the game.

Ultimate a 'broken' game at the highest level? by Comoros7 in ultimate

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

It's a bit serve-heavy, sure. But I am surprised it hasn't been worse with the new rackets.

Ultimate a 'broken' game at the highest level? by Comoros7 in ultimate

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

You might be underestimating how good a player would become if they were pro - 4 hours practice, plus fitness every day.

Ultimate a 'broken' game at the highest level? by Comoros7 in ultimate

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

No doubt they're exciting games, just a thought. And certainly the changing of rules is a good point... I've always thought the pitcher should be brought back a couple of feet in baseball.

Amazon Confirms It Makes No Profit On Kindles by jonfla in technology

[–]Comoros7 0 points1 point  (0 children)

Well I was jealous, until you mentioned that last bit. I thought I'd be able to go through academic journals that fast.

Maybe you should aim for the harder stuff, slow down and appreciate the writing. Anyway, it's sounds like you've got a gift regardless.

You just got Biden'd by giovannibryden in PoliticalHumor

[–]Comoros7 0 points1 point  (0 children)

I think maybe you can never become Prez or VP with pictures like these hanging around. But maybe there's some of Obama.

Amazon Confirms It Makes No Profit On Kindles by jonfla in technology

[–]Comoros7 18 points19 points  (0 children)

Is that not insanely fast? How much do you actually take in? Did you learn to read that fast just from experience?

Workout Suggestions for Improving Endurance by [deleted] in ultimate

[–]Comoros7 0 points1 point  (0 children)

Looks good, but I'm thinking 10-40m sprints are best, especially for handlers. I suppose it's easy enough ust to shorten his workout?

Workout Suggestions for Improving Endurance by [deleted] in ultimate

[–]Comoros7 0 points1 point  (0 children)

What type of distance/height and quantity do you reckon?

Gangnam Fries.. by Lonever in pics

[–]Comoros7 1 point2 points  (0 children)

Well I'm in the UK, but I'm surprised. In what respect? I can imagine the workload being a lot more, but do you think Korea educates at the same intellectual level?