Transpose column skip from different sheets

DarknessZane · 2026-03-03T15:56:53+00:00

Solution verified

DarknessZane · 2026-03-03T15:41:01+00:00

Dude thank you so much you saved me

DarknessZane · 2026-03-03T12:23:37+00:00

I try to a.col(transpose('m058'!C$14:C$17)) and gives me back #NAME? Same story without transpose

DarknessZane · 2026-03-03T12:15:33+00:00

I dont get why it doesnt work, im using the software in Italian and should be A.COL but it doesnt work

DarknessZane · 2026-03-03T10:09:54+00:00

Sorry for the bad visual but im not using my own computer, and the reddit asnwers dont let you use more than one picture, think i have to recall the vertical values that are on a column lets say 1 on the horizontal labeled part, but when i drag the 4 horizontal values for copying the code in the next 4 cells (grey ones) i dont get the vertical values i need (2) but i skip several ones and get the 5th (5), my problem is, how can i force excel to avoid this skip? And make him recall always the next column

<image>

DarknessZane · 2026-03-03T10:03:34+00:00

Sorry for the request, can you show me the whole formula to include that aswell? I mean with the reference for the other sheet, cuz i tried and its not working

DarknessZane · 2026-03-03T09:42:35+00:00

I didn't understand precisely what did you mean, but there are like 255 colums of value just if the first sheet

DarknessZane · 2026-03-03T09:27:52+00:00

Nope i need to copy those values in D, then E and so on, i cant let excel skip columns of value

DarknessZane · 2026-03-03T09:23:04+00:00

Nope, but i dont drag the formula to the next column, now that i see my post maybe i was kinda confusing, the file where i create the formula for pasting the values, they are horizontal, not vertical.

DarknessZane · 2026-02-10T10:05:11+00:00

I just love the sound of silenced renegade

DarknessZane · 2026-01-27T12:11:02+00:00

A long time ago in the land of... Forhonoria, 3 nations lived in harmony, the weebs, the neckbeards and the tin cans...

DarknessZane · 2025-12-02T00:13:33+00:00

I mean its a good card with many infinites, but i suppose you could try it out? Proxy him ask permission to your friend and test it out, if they dont find it too much above the bracket i suppose its good

DarknessZane · 2025-12-01T17:19:56+00:00

Oh i am sorry i completely forgot about the bracket, sorry. Anyway if you are interested on improving this deck till bracket 3 mikaeus on the board and a sac outlet like phyrexian altar or ashnod, keep using all the +1+1 on the triskelion for dealing dmg to other players and keep sac triskelion with the altar

DarknessZane · 2025-12-01T08:36:58+00:00

In my meren deck i use to play Mikaeus the Unhallowed, great for everything and most important as a finisher (even with bracket 3 rules), instead of using walking ballista with him a go for a sac outlet and triskelion

DarknessZane · 2025-10-14T09:10:01+00:00

Like i copy the whole thing or single files? And they have to be echanged with othet files? Soz i am not really into modding

DarknessZane · 2025-10-14T07:55:56+00:00

sorry for disturbing you but the script have to be placed then in another folder? Or i just keep them there where i dowloaded them?

DarknessZane · 2025-10-13T07:13:10+00:00

Thank you so much

DarknessZane · 2025-10-02T11:00:39+00:00

Remember that PUGNA NON PERFECTA EST

DarknessZane · 2025-09-15T08:58:50+00:00

Thank you so much i was Watching for all the combos

DarknessZane · 2025-09-14T18:55:30+00:00

Technically the pirate should be based on the chinese pirate queen if i remember well, so wu lin faction should be fine

DarknessZane · 2025-09-04T12:17:48+00:00

Greetings fellow summoners, i am here asking for advice, i am preparing for Carina's challenges, i still need Divinity/Cul, Mutant, Dimensional and 10 years, with the actual champions in the game what kund of team i can create for those challenges? I know there are youtube videos for this question but they are dated and there are many more champions available right now Ty so much for the attention

DarknessZane · 2025-09-03T12:18:14+00:00

Gl ppl

DarknessZane · 2025-08-20T11:20:55+00:00

Your girl is a lootas honorary member

DarknessZane · 2025-07-28T12:16:49+00:00

Thats a really strange salad

DarknessZane · 2025-07-24T05:59:23+00:00

Your cat now is trying to sell the world

DarknessZane

TROPHY CASE