List all values in excel range with a condition and date range The 2019 Stack Overflow Developer Survey Results Are In Unicorn Meta Zoo #1: Why another podcast? Announcing the arrival of Valued Associate #679: Cesar Manara The Ask Question Wizard is Live! Data science time! April 2019 and salary with experienceIs it possible to force Excel recognize UTF-8 CSV files automatically?Excel - Conditional Formatting - insert rowDetermine longest date range, from two date ranges - ExcelConditional Standard Deviation Formula in ExcelExcel matching cell value and date rangeIf a date meets the date range criterion in COUNTIFSExcel Conditional Formatting if number from range 1 exists in range 2Excel Conditional formatting formula and ranges (VBA)Excel formula to say if a date range is available/unavailable from a list of date ranges?Excel - Multiple formula required to use values on sheet to find those values in a list to then create a range and count certain critera
For what reasons would an animal species NOT cross a *horizontal* land bridge?
How do you keep chess fun when your opponent constantly beats you?
Working through the single responsibility principle (SRP) in Python when calls are expensive
Is every episode of "Where are my Pants?" identical?
Match Roman Numerals
What can I do if neighbor is blocking my solar panels intentionally?
Is there a writing software that you can sort scenes like slides in PowerPoint?
Deal with toxic manager when you can't quit
What force causes entropy to increase?
How to support a colleague who finds meetings extremely tiring?
Did the UK government pay "millions and millions of dollars" to try to snag Julian Assange?
"is" operation returns false even though two objects have same id
What is the role of 'For' here?
Would an alien lifeform be able to achieve space travel if lacking in vision?
"... to apply for a visa" or "... and applied for a visa"?
How to read αἱμύλιος or when to aspirate
Make it rain characters
Button changing its text & action. Good or terrible?
Am I ethically obligated to go into work on an off day if the reason is sudden?
Keeping a retro style to sci-fi spaceships?
Why not take a picture of a closer black hole?
Does Parliament hold absolute power in the UK?
Simulating Exploding Dice
Visa regaring travelling European country
List all values in excel range with a condition and date range
The 2019 Stack Overflow Developer Survey Results Are In
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar Manara
The Ask Question Wizard is Live!
Data science time! April 2019 and salary with experienceIs it possible to force Excel recognize UTF-8 CSV files automatically?Excel - Conditional Formatting - insert rowDetermine longest date range, from two date ranges - ExcelConditional Standard Deviation Formula in ExcelExcel matching cell value and date rangeIf a date meets the date range criterion in COUNTIFSExcel Conditional Formatting if number from range 1 exists in range 2Excel Conditional formatting formula and ranges (VBA)Excel formula to say if a date range is available/unavailable from a list of date ranges?Excel - Multiple formula required to use values on sheet to find those values in a list to then create a range and count certain critera
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
My excel data example
I have two conditions to draw the value in another sheet:
- Customer name
- Date Range From... To...
Example:
I would like to draw all Campaign number that related to Customer from 01/03/2019 to 21/03/2019.
Expected Result
Choose: Customer A, Date from 01/03/2019 to 20/03/2019 -> CPC1
Choose: Customer A, Date from 01/03/2019 to 21/03/2019 -> CPC1, CPC3
I would like the result like this
Could anyone suggest me what is the formula in excel to achieve this?
excel
asked Mar 22 at 5:45
Ryan NguyenRyan Nguyen
33
add a comment |
My excel data example
I have two conditions to draw the value in another sheet:
- Customer name
- Date Range From... To...
Example:
I would like to draw all Campaign number that related to Customer from 01/03/2019 to 21/03/2019.
Expected Result
Choose: Customer A, Date from 01/03/2019 to 20/03/2019 -> CPC1
Choose: Customer A, Date from 01/03/2019 to 21/03/2019 -> CPC1, CPC3
I would like the result like this
Could anyone suggest me what is the formula in excel to achieve this?
excel
asked Mar 22 at 5:45
Ryan NguyenRyan Nguyen
33
This is difficult to understand. Can you give an example of what you want the results to be?
– wavery
Mar 22 at 5:55
and where would you like us to put the results?
– user11217663
Mar 22 at 6:19
I have added the picture showing how i would like the result to be. if I choose date range and customer like in the screenshot, it will list all Campaign number that related to this customer in column C.
– Ryan Nguyen
Mar 22 at 6:36
could anyone help me on this please??
– Ryan Nguyen
Mar 22 at 7:28
add a comment |
My excel data example
I have two conditions to draw the value in another sheet:
- Customer name
- Date Range From... To...
Example:
I would like to draw all Campaign number that related to Customer from 01/03/2019 to 21/03/2019.
Expected Result
Choose: Customer A, Date from 01/03/2019 to 20/03/2019 -> CPC1
Choose: Customer A, Date from 01/03/2019 to 21/03/2019 -> CPC1, CPC3
I would like the result like this
Could anyone suggest me what is the formula in excel to achieve this?
excel
asked Mar 22 at 5:45
Ryan NguyenRyan Nguyen
33
My excel data example
I have two conditions to draw the value in another sheet:
- Customer name
- Date Range From... To...
Example:
I would like to draw all Campaign number that related to Customer from 01/03/2019 to 21/03/2019.
Expected Result
Choose: Customer A, Date from 01/03/2019 to 20/03/2019 -> CPC1
Choose: Customer A, Date from 01/03/2019 to 21/03/2019 -> CPC1, CPC3
I would like the result like this
Could anyone suggest me what is the formula in excel to achieve this?
excel
excel
asked Mar 22 at 5:45
Ryan NguyenRyan Nguyen
33
asked Mar 22 at 5:45
Ryan NguyenRyan Nguyen
33
edited Mar 22 at 6:33
Ryan Nguyen
asked Mar 22 at 5:45
Ryan NguyenRyan Nguyen
33
asked Mar 22 at 5:45
Ryan NguyenRyan Nguyen
33
asked Mar 22 at 5:45
Ryan NguyenRyan Nguyen
33
33
This is difficult to understand. Can you give an example of what you want the results to be?
– wavery
Mar 22 at 5:55
and where would you like us to put the results?
– user11217663
Mar 22 at 6:19
I have added the picture showing how i would like the result to be. if I choose date range and customer like in the screenshot, it will list all Campaign number that related to this customer in column C.
– Ryan Nguyen
Mar 22 at 6:36
could anyone help me on this please??
– Ryan Nguyen
Mar 22 at 7:28
add a comment |
This is difficult to understand. Can you give an example of what you want the results to be?
– wavery
Mar 22 at 5:55
and where would you like us to put the results?
– user11217663
Mar 22 at 6:19
I have added the picture showing how i would like the result to be. if I choose date range and customer like in the screenshot, it will list all Campaign number that related to this customer in column C.
– Ryan Nguyen
Mar 22 at 6:36
could anyone help me on this please??
– Ryan Nguyen
Mar 22 at 7:28
This is difficult to understand. Can you give an example of what you want the results to be?
– wavery
Mar 22 at 5:55
This is difficult to understand. Can you give an example of what you want the results to be?
– wavery
Mar 22 at 5:55
and where would you like us to put the results?
– user11217663
Mar 22 at 6:19
and where would you like us to put the results?
– user11217663
Mar 22 at 6:19
I have added the picture showing how i would like the result to be. if I choose date range and customer like in the screenshot, it will list all Campaign number that related to this customer in column C.
– Ryan Nguyen
Mar 22 at 6:36
I have added the picture showing how i would like the result to be. if I choose date range and customer like in the screenshot, it will list all Campaign number that related to this customer in column C.
– Ryan Nguyen
Mar 22 at 6:36
could anyone help me on this please??
– Ryan Nguyen
Mar 22 at 7:28
could anyone help me on this please??
– Ryan Nguyen
Mar 22 at 7:28
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
);
);
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%2f55293574%2flist-all-values-in-excel-range-with-a-condition-and-date-range%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
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.
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%2f55293574%2flist-all-values-in-excel-range-with-a-condition-and-date-range%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
This is difficult to understand. Can you give an example of what you want the results to be?
– wavery
Mar 22 at 5:55
and where would you like us to put the results?
– user11217663
Mar 22 at 6:19
I have added the picture showing how i would like the result to be. if I choose date range and customer like in the screenshot, it will list all Campaign number that related to this customer in column C.
– Ryan Nguyen
Mar 22 at 6:36
could anyone help me on this please??
– Ryan Nguyen
Mar 22 at 7:28