Return date based on another cell's criteriaHow to return multiple values from a function?Getting the index of the returned max or min item using max()/min() on a listMYSQL Time difference between MAX and MIN from single tableSQL: Selecting the min and max values but with combinations where there are more than 2 valuesSelect min/max from group defined by one column as subgroup of another - SQL, HPVerticaSQL - How can I Group sets of sequential numbers and return the MIN and Max DatesFinding min max in 3d numpy arrayfinding average, min and max in assemblyTrying to find min and max from txt file with strings and floatsJava max and min of array returning wrong numbers
Noob at soldering, can anyone explain why my circuit won't work?
How could we transfer large amounts of energy sourced in space to Earth?
How can a Lich look like a human without magic?
Why does TypeScript pack a Class in an IIFE?
Make all the squares explode
What does i386 mean on macOS Mojave?
Should these notes be played as a chord or one after another?
Why is it so slow when assigning a concatenated string to a variable in python?
Set a camera to free fall like a Rigid Body?
Are there variations of the regular runtimes of the Big-O-Notation?
Ex-manager wants to stay in touch, I don't want to
How do I get past a 3-year ban from overstay with VWP?
Early arrival in Australia, early hotel check in not available
When do you stop "pushing" a book?
We are two immediate neighbors who forged our own powers to form concatenated relationship. Who are we?
How to pronounce "r" after a "g"?
What can cause a never-frozen indoor copper drain pipe to crack?
51% attack - apparently very easy? refering to CZ's "rollback btc chain" - How to make sure such corruptible scenario can never happen so easily?
Ubuntu won't let me edit or delete .vimrc file
Does the 500 feet falling cap apply per fall, or per turn?
Why was this sacrifice sufficient?
How to deal with inappropriate comments during interviews for academic positions?
Was there ever any real use for a 6800-based Apple I?
International Code of Ethics for order of co-authors in research papers
Return date based on another cell's criteria
How to return multiple values from a function?Getting the index of the returned max or min item using max()/min() on a listMYSQL Time difference between MAX and MIN from single tableSQL: Selecting the min and max values but with combinations where there are more than 2 valuesSelect min/max from group defined by one column as subgroup of another - SQL, HPVerticaSQL - How can I Group sets of sequential numbers and return the MIN and Max DatesFinding min max in 3d numpy arrayfinding average, min and max in assemblyTrying to find min and max from txt file with strings and floatsJava max and min of array returning wrong numbers
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I am trying to find a formula that will return the first and last date based on criteria from another cell. I'm assuming that I will need to use MIN and MAX but I can't seem to figure out how. I've added a screen shot how the results should look.enter image description here
max return-value min
asked Mar 23 at 11:15
bprin87bprin87
12
add a comment |
I am trying to find a formula that will return the first and last date based on criteria from another cell. I'm assuming that I will need to use MIN and MAX but I can't seem to figure out how. I've added a screen shot how the results should look.enter image description here
max return-value min
asked Mar 23 at 11:15
bprin87bprin87
12
add a comment |
I am trying to find a formula that will return the first and last date based on criteria from another cell. I'm assuming that I will need to use MIN and MAX but I can't seem to figure out how. I've added a screen shot how the results should look.enter image description here
max return-value min
asked Mar 23 at 11:15
bprin87bprin87
12
I am trying to find a formula that will return the first and last date based on criteria from another cell. I'm assuming that I will need to use MIN and MAX but I can't seem to figure out how. I've added a screen shot how the results should look.enter image description here
max return-value min
max return-value min
asked Mar 23 at 11:15
bprin87bprin87
12
asked Mar 23 at 11:15
bprin87bprin87
12
asked Mar 23 at 11:15
bprin87bprin87
12
asked Mar 23 at 11:15
bprin87bprin87
12
asked Mar 23 at 11:15
bprin87bprin87
12
12
add a comment |
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%2f55313119%2freturn-date-based-on-another-cells-criteria%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%2f55313119%2freturn-date-based-on-another-cells-criteria%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
