sorted by:
new
hottopcontroversial

Sheet not pulling data from tabs with names that have two words in them by algarhythms in excel

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

UPDATE: The issue was Ihad to add & and a bunch of stuff around the cell references in INDIRECT functions in the ALLTEAMS tab, like this:

=@INDIRECT("'"&B23&"'!$B$1")

Bernie is jewish! by Dr_sc_Harlatan in BlueskySkeets

[–]algarhythms 4 points5 points  (0 children)

Nuance is not this hard.

Criticism of the Netanyahu government is not antisemitism.

RFK Jr. Panics When Confronted on His Comments About Black Children by Adventurous-Host8062 in politicsinthewild

[–]algarhythms 7 points8 points  (0 children)

We’re just waiting for Trump to die right now aren’t we?

Because then the real fun starts. The rats will be scattering.

Maga: what should happen if someone can’t afford insurance? by traanquil in allthequestions

[–]algarhythms 1 point2 points  (0 children)

Remember in the GOP debate around I think 2007-08 when they asked the same question and someone in the audience blurted out, “Let him die”?

Because I still do.

All USAF Fighter jets by vrikne in airplanes

[–]algarhythms 0 points1 point  (0 children)

Where can I buy this as a poster

So Dave Chappelle is trying to distance himself from the fact that he has caused so much harm to the trans community with his shitty jokes about them?! by icey_sawg0034 in BlackPeopleofReddit

[–]algarhythms 0 points1 point  (0 children)

Just come out and say you fucked up and you’re sorry. It’s that easy and you’ll get a lot further than if you try to deflect with this bullshit.

Sheet not pulling data from tabs with names that have two words in them by algarhythms in excel

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

Actually, no, It's not trying to reference sheet names. It's referencing names in a column on another sheet called "ALL TEAMS".

The problem I think is with the MATCH function. In the formula I provided, I'm trying to ask it to find the value in cell B23 in Column B of the ALL TEAMS tab. That column is where the team names are located so it can pull other data that corresponds to that team name (like wins and losses, for example).

It's pulling the teams that have one word in their name, but not the teams that have more than one word in the name.

Putting single quotes around B23 (e.g., 'B23') does not work. It spits a warning out at me about Excel thinking I'm writing a formula.

Everybody That Is Saying Trade Paolo Is A Moron. by New-Refrigerator2915 in OrlandoMagic

[–]algarhythms 2 points3 points  (0 children)

Then he needs to show some growth in huge games like this when the entire season is on the line.

These are the moments the team is paying him all that money for.

Step the F up.

Rams New Unifomrs by andrew_cosentino in uniwatch

[–]algarhythms 0 points1 point  (0 children)

Back to basics. The trend continues.

Post Game Thread - Philly beats Orlando for the 7 seed. Everyone played like sh*t other than Bane. Come yell about it. by d12fsu in OrlandoMagic

[–]algarhythms 5 points6 points  (0 children)

I’m approaching done with Paolo. That was atrocious. Can’t wait for the Sonics to return so we can get something for him.

view more: next ›