How to order excel list base on the path given in other column with VBAI need to duplicate a word file and...
Are there any consumables that function as addictive (psychedelic) drugs?
What typically incentivizes a professor to change jobs to a lower ranking university?
Is there a familial term for apples and pears?
Why can't I see bouncing of a switch on an oscilloscope?
How to type dʒ symbol (IPA) on Mac?
Patience, young "Padovan"
What are these boxed doors outside store fronts in New York?
Is it possible to do 50 km distance without any previous training?
Why is this code 6.5x slower with optimizations enabled?
Why is an old chain unsafe?
Banach space and Hilbert space topology
Why Is Death Allowed In the Matrix?
Can a German sentence have two subjects?
What is the meaning of "of trouble" in the following sentence?
Can I make popcorn with any corn?
How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?
Japan - Plan around max visa duration
"which" command doesn't work / path of Safari?
Copenhagen passport control - US citizen
Shell script can be run only with sh command
How old can references or sources in a thesis be?
How can bays and straits be determined in a procedurally generated map?
Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?
Should I join an office cleaning event for free?
How to order excel list base on the path given in other column with VBA
I need to duplicate a word file and name it based on an excel list or other list formatExcel Single column into rows, VBA script insightPopulate one column with data from a list and match other column dataConvert a column B into a comma separated list , “ORDER BY” Colum AExcel - How to return a list of values in one column if a value in another column meets certain criteriaCalculate total based on an IF statementSort Excel by derived column then by other columnEXCEL: How to jump to first (or next) duplicate value in a sorted column?Excel VBA - how to automatically correspond ranges to valueProgrammatically count how many times ALL values in a column appears from an excel document
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I need to sort and get the count of elements base in the path. For example I have next excel format
Column A Column B Column C
Name Proyect Path 1
Name Proyect Path 2
Name Proyect 2 Path 1
Name Proyect 2 Path 2
I need to get how many elements are in Path 1, Path 2 and so on (I have a list of +3000 elements)
microsoft-excel vba macros microsoft-excel-2016
edited 2 days ago
cybernetic.nomad
2,661617
asked 2 days ago
Jesus RodriguezJesus Rodriguez
1
New contributor
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I need to sort and get the count of elements base in the path. For example I have next excel format
Column A Column B Column C
Name Proyect Path 1
Name Proyect Path 2
Name Proyect 2 Path 1
Name Proyect 2 Path 2
I need to get how many elements are in Path 1, Path 2 and so on (I have a list of +3000 elements)
microsoft-excel vba macros microsoft-excel-2016
edited 2 days ago
cybernetic.nomad
2,661617
asked 2 days ago
Jesus RodriguezJesus Rodriguez
1
New contributor
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
"I need to get how many elements" do you mean to say you need to count how many times "Path 1" appears in columnC? If yes,COUNTIFis what you're looking for
– cybernetic.nomad
2 days ago
Hi. No, what i need is to create a list of how many elements from Column A have Path 1, path 2...
– Jesus Rodriguez
2 days ago
1
this may help you generate sample data that would clarify things. A sample output would also be useful.
– cybernetic.nomad
2 days ago
@JesusRodriguez,, since it's little confusing so better edit the post and include the expected output, will help us to fix the issue!!
– Rajesh S
yesterday
add a comment |
I need to sort and get the count of elements base in the path. For example I have next excel format
Column A Column B Column C
Name Proyect Path 1
Name Proyect Path 2
Name Proyect 2 Path 1
Name Proyect 2 Path 2
I need to get how many elements are in Path 1, Path 2 and so on (I have a list of +3000 elements)
microsoft-excel vba macros microsoft-excel-2016
edited 2 days ago
cybernetic.nomad
2,661617
asked 2 days ago
Jesus RodriguezJesus Rodriguez
1
New contributor
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I need to sort and get the count of elements base in the path. For example I have next excel format
Column A Column B Column C
Name Proyect Path 1
Name Proyect Path 2
Name Proyect 2 Path 1
Name Proyect 2 Path 2
I need to get how many elements are in Path 1, Path 2 and so on (I have a list of +3000 elements)
microsoft-excel vba macros microsoft-excel-2016
microsoft-excel vba macros microsoft-excel-2016
edited 2 days ago
cybernetic.nomad
2,661617
asked 2 days ago
Jesus RodriguezJesus Rodriguez
1
New contributor
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
cybernetic.nomad
2,661617
asked 2 days ago
Jesus RodriguezJesus Rodriguez
1
New contributor
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
cybernetic.nomad
2,661617
edited 2 days ago
cybernetic.nomad
2,661617
edited 2 days ago
cybernetic.nomad
2,661617
2,661617
asked 2 days ago
Jesus RodriguezJesus Rodriguez
1
New contributor
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
Jesus RodriguezJesus Rodriguez
1
asked 2 days ago
Jesus RodriguezJesus Rodriguez
1
1
New contributor
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Jesus Rodriguez is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
"I need to get how many elements" do you mean to say you need to count how many times "Path 1" appears in columnC? If yes,COUNTIFis what you're looking for
– cybernetic.nomad
2 days ago
Hi. No, what i need is to create a list of how many elements from Column A have Path 1, path 2...
– Jesus Rodriguez
2 days ago
1
this may help you generate sample data that would clarify things. A sample output would also be useful.
– cybernetic.nomad
2 days ago
@JesusRodriguez,, since it's little confusing so better edit the post and include the expected output, will help us to fix the issue!!
– Rajesh S
yesterday
add a comment |
"I need to get how many elements" do you mean to say you need to count how many times "Path 1" appears in columnC? If yes,COUNTIFis what you're looking for
– cybernetic.nomad
2 days ago
Hi. No, what i need is to create a list of how many elements from Column A have Path 1, path 2...
– Jesus Rodriguez
2 days ago
1
this may help you generate sample data that would clarify things. A sample output would also be useful.
– cybernetic.nomad
2 days ago
@JesusRodriguez,, since it's little confusing so better edit the post and include the expected output, will help us to fix the issue!!
– Rajesh S
yesterday
"I need to get how many elements" do you mean to say you need to count how many times "Path 1" appears in column
C? If yes, COUNTIF is what you're looking for– cybernetic.nomad
2 days ago
"I need to get how many elements" do you mean to say you need to count how many times "Path 1" appears in column
C? If yes, COUNTIF is what you're looking for– cybernetic.nomad
2 days ago
Hi. No, what i need is to create a list of how many elements from Column A have Path 1, path 2...
– Jesus Rodriguez
2 days ago
Hi. No, what i need is to create a list of how many elements from Column A have Path 1, path 2...
– Jesus Rodriguez
2 days ago
1
1
this may help you generate sample data that would clarify things. A sample output would also be useful.
– cybernetic.nomad
2 days ago
this may help you generate sample data that would clarify things. A sample output would also be useful.
– cybernetic.nomad
2 days ago
@JesusRodriguez,, since it's little confusing so better edit the post and include the expected output, will help us to fix the issue!!
– Rajesh S
yesterday
@JesusRodriguez,, since it's little confusing so better edit the post and include the expected output, will help us to fix the issue!!
– Rajesh S
yesterday
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
Jesus Rodriguez is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1422005%2fhow-to-order-excel-list-base-on-the-path-given-in-other-column-with-vba%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
Jesus Rodriguez is a new contributor. Be nice, and check out our Code of Conduct.
Jesus Rodriguez is a new contributor. Be nice, and check out our Code of Conduct.
Jesus Rodriguez is a new contributor. Be nice, and check out our Code of Conduct.
Jesus Rodriguez is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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.
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%2fsuperuser.com%2fquestions%2f1422005%2fhow-to-order-excel-list-base-on-the-path-given-in-other-column-with-vba%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
"I need to get how many elements" do you mean to say you need to count how many times "Path 1" appears in column
C? If yes,COUNTIFis what you're looking for– cybernetic.nomad
2 days ago
Hi. No, what i need is to create a list of how many elements from Column A have Path 1, path 2...
– Jesus Rodriguez
2 days ago
1
this may help you generate sample data that would clarify things. A sample output would also be useful.
– cybernetic.nomad
2 days ago
@JesusRodriguez,, since it's little confusing so better edit the post and include the expected output, will help us to fix the issue!!
– Rajesh S
yesterday