Mixing
Transpose limit characters 50000 problem in google sheets
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
I am trying to use this formula:
=sort(unique(transpose(split(arrayformula(concatenate(if(len(C3:Y195)>0,C3:Y195&";",""))),";"))))
But the characters limit is not enough. How can I fix this?
google-sheets spreadsheet
edited Jan 3 at 11:56
Soumya Kanti
8221123
asked Jan 3 at 11:36
Emma HerreroEmma Herrero
62
add a comment |
0
I am trying to use this formula:
=sort(unique(transpose(split(arrayformula(concatenate(if(len(C3:Y195)>0,C3:Y195&";",""))),";"))))
But the characters limit is not enough. How can I fix this?
google-sheets spreadsheet
edited Jan 3 at 11:56
Soumya Kanti
8221123
asked Jan 3 at 11:36
Emma HerreroEmma Herrero
62
Welcome. Would you please share your spreadsheet. It's quite difficult to tell how to solve such a problem without know what the data looks like, as well as the proposed outcome.
– Tedinoz
Jan 4 at 21:40
docs.google.com/spreadsheets/d/…
– Emma Herrero
Jan 7 at 12:57
@Welcome. I've looked at your spreadsheet - that's quite a formula but its purpose isn't obvious. Please explain the problem that you are trying to solve with this spreadsheet and the formula (as well as the other formulae) on the "ID Unico" sheet. Re-read the help section on How to ask a good question and consider editing your question to provide more information.
– Tedinoz
Jan 7 at 22:59
FWIW, the formula in question was doomed from the start. Possibly you've adapted it from another Q&A, but it is fatally flawed. The heart of the formula islen('EMPLOYEE DEC'!C3:Z192), but all the values on "EMPLOYEE DEC" are text (test it withistext()), andlenexpects numbers. Also, the formula appears to appears to duplicate (though transpose) the data on "EMPLOYEE DEC"; that's a recipe for a very big and sluggish spreadsheet. Hopefully we can help you get a more efficient solution when you describe the problem you're trying to solve.
– Tedinoz
Jan 8 at 4:27
add a comment |
0
0
0
I am trying to use this formula:
=sort(unique(transpose(split(arrayformula(concatenate(if(len(C3:Y195)>0,C3:Y195&";",""))),";"))))
But the characters limit is not enough. How can I fix this?
google-sheets spreadsheet
edited Jan 3 at 11:56
Soumya Kanti
8221123
asked Jan 3 at 11:36
Emma HerreroEmma Herrero
62
I am trying to use this formula:
=sort(unique(transpose(split(arrayformula(concatenate(if(len(C3:Y195)>0,C3:Y195&";",""))),";"))))
But the characters limit is not enough. How can I fix this?
google-sheets spreadsheet
google-sheets spreadsheet
edited Jan 3 at 11:56
Soumya Kanti
8221123
asked Jan 3 at 11:36
Emma HerreroEmma Herrero
62
edited Jan 3 at 11:56
Soumya Kanti
8221123
asked Jan 3 at 11:36
Emma HerreroEmma Herrero
62
edited Jan 3 at 11:56
Soumya Kanti
8221123
edited Jan 3 at 11:56
Soumya Kanti
8221123
edited Jan 3 at 11:56
Soumya Kanti
8221123
8221123
asked Jan 3 at 11:36
Emma HerreroEmma Herrero
62
asked Jan 3 at 11:36
Emma HerreroEmma Herrero
62
asked Jan 3 at 11:36
Emma HerreroEmma Herrero
62
62
Welcome. Would you please share your spreadsheet. It's quite difficult to tell how to solve such a problem without know what the data looks like, as well as the proposed outcome.
– Tedinoz
Jan 4 at 21:40
docs.google.com/spreadsheets/d/…
– Emma Herrero
Jan 7 at 12:57
@Welcome. I've looked at your spreadsheet - that's quite a formula but its purpose isn't obvious. Please explain the problem that you are trying to solve with this spreadsheet and the formula (as well as the other formulae) on the "ID Unico" sheet. Re-read the help section on How to ask a good question and consider editing your question to provide more information.
– Tedinoz
Jan 7 at 22:59
FWIW, the formula in question was doomed from the start. Possibly you've adapted it from another Q&A, but it is fatally flawed. The heart of the formula islen('EMPLOYEE DEC'!C3:Z192), but all the values on "EMPLOYEE DEC" are text (test it withistext()), andlenexpects numbers. Also, the formula appears to appears to duplicate (though transpose) the data on "EMPLOYEE DEC"; that's a recipe for a very big and sluggish spreadsheet. Hopefully we can help you get a more efficient solution when you describe the problem you're trying to solve.
– Tedinoz
Jan 8 at 4:27
add a comment |
Welcome. Would you please share your spreadsheet. It's quite difficult to tell how to solve such a problem without know what the data looks like, as well as the proposed outcome.
– Tedinoz
Jan 4 at 21:40
docs.google.com/spreadsheets/d/…
– Emma Herrero
Jan 7 at 12:57
@Welcome. I've looked at your spreadsheet - that's quite a formula but its purpose isn't obvious. Please explain the problem that you are trying to solve with this spreadsheet and the formula (as well as the other formulae) on the "ID Unico" sheet. Re-read the help section on How to ask a good question and consider editing your question to provide more information.
– Tedinoz
Jan 7 at 22:59
FWIW, the formula in question was doomed from the start. Possibly you've adapted it from another Q&A, but it is fatally flawed. The heart of the formula islen('EMPLOYEE DEC'!C3:Z192), but all the values on "EMPLOYEE DEC" are text (test it withistext()), andlenexpects numbers. Also, the formula appears to appears to duplicate (though transpose) the data on "EMPLOYEE DEC"; that's a recipe for a very big and sluggish spreadsheet. Hopefully we can help you get a more efficient solution when you describe the problem you're trying to solve.
– Tedinoz
Jan 8 at 4:27
Welcome. Would you please share your spreadsheet. It's quite difficult to tell how to solve such a problem without know what the data looks like, as well as the proposed outcome.
– Tedinoz
Jan 4 at 21:40
Welcome. Would you please share your spreadsheet. It's quite difficult to tell how to solve such a problem without know what the data looks like, as well as the proposed outcome.
– Tedinoz
Jan 4 at 21:40
docs.google.com/spreadsheets/d/…
– Emma Herrero
Jan 7 at 12:57
docs.google.com/spreadsheets/d/…
– Emma Herrero
Jan 7 at 12:57
@Welcome. I've looked at your spreadsheet - that's quite a formula but its purpose isn't obvious. Please explain the problem that you are trying to solve with this spreadsheet and the formula (as well as the other formulae) on the "ID Unico" sheet. Re-read the help section on How to ask a good question and consider editing your question to provide more information.
– Tedinoz
Jan 7 at 22:59
@Welcome. I've looked at your spreadsheet - that's quite a formula but its purpose isn't obvious. Please explain the problem that you are trying to solve with this spreadsheet and the formula (as well as the other formulae) on the "ID Unico" sheet. Re-read the help section on How to ask a good question and consider editing your question to provide more information.
– Tedinoz
Jan 7 at 22:59
FWIW, the formula in question was doomed from the start. Possibly you've adapted it from another Q&A, but it is fatally flawed. The heart of the formula is
len('EMPLOYEE DEC'!C3:Z192), but all the values on "EMPLOYEE DEC" are text (test it with istext()), and len expects numbers. Also, the formula appears to appears to duplicate (though transpose) the data on "EMPLOYEE DEC"; that's a recipe for a very big and sluggish spreadsheet. Hopefully we can help you get a more efficient solution when you describe the problem you're trying to solve.– Tedinoz
Jan 8 at 4:27
FWIW, the formula in question was doomed from the start. Possibly you've adapted it from another Q&A, but it is fatally flawed. The heart of the formula is
len('EMPLOYEE DEC'!C3:Z192), but all the values on "EMPLOYEE DEC" are text (test it with istext()), and len expects numbers. Also, the formula appears to appears to duplicate (though transpose) the data on "EMPLOYEE DEC"; that's a recipe for a very big and sluggish spreadsheet. Hopefully we can help you get a more efficient solution when you describe the problem you're trying to solve.– Tedinoz
Jan 8 at 4:27
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54021510%2ftranspose-limit-characters-50000-problem-in-google-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54021510%2ftranspose-limit-characters-50000-problem-in-google-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Welcome. Would you please share your spreadsheet. It's quite difficult to tell how to solve such a problem without know what the data looks like, as well as the proposed outcome.
– Tedinoz
Jan 4 at 21:40
docs.google.com/spreadsheets/d/…
– Emma Herrero
Jan 7 at 12:57
@Welcome. I've looked at your spreadsheet - that's quite a formula but its purpose isn't obvious. Please explain the problem that you are trying to solve with this spreadsheet and the formula (as well as the other formulae) on the "ID Unico" sheet. Re-read the help section on How to ask a good question and consider editing your question to provide more information.
– Tedinoz
Jan 7 at 22:59
FWIW, the formula in question was doomed from the start. Possibly you've adapted it from another Q&A, but it is fatally flawed. The heart of the formula is
len('EMPLOYEE DEC'!C3:Z192), but all the values on "EMPLOYEE DEC" are text (test it withistext()), andlenexpects numbers. Also, the formula appears to appears to duplicate (though transpose) the data on "EMPLOYEE DEC"; that's a recipe for a very big and sluggish spreadsheet. Hopefully we can help you get a more efficient solution when you describe the problem you're trying to solve.– Tedinoz
Jan 8 at 4:27