Mixing
Looking up data based on dates in excel
$begingroup$
I have 2 data sets, A and B. Each set includes an ID number, a QTY and a posting date. I want to quantify how many times an ID occurs in set A and how many times an ID occurs in set B after it has occurred in set A.
For example:
So we can see that ID 10000104400 has total quantity of -2 between 4/30/18 - 7/23/2018 and I would only care about what was adjusted in after these dates. So looking at Data set B I only care about the quantity of 1 on 9/26/2018.
I've tried using vlookups and sumifs but I am having a hard time writing a formula to get the output I am looking for.
Any help would be appreciated!
algorithms
asked Jan 7 at 18:33
Numb3ersNumb3ers
425
$endgroup$
add a comment |
$begingroup$
I have 2 data sets, A and B. Each set includes an ID number, a QTY and a posting date. I want to quantify how many times an ID occurs in set A and how many times an ID occurs in set B after it has occurred in set A.
For example:
So we can see that ID 10000104400 has total quantity of -2 between 4/30/18 - 7/23/2018 and I would only care about what was adjusted in after these dates. So looking at Data set B I only care about the quantity of 1 on 9/26/2018.
I've tried using vlookups and sumifs but I am having a hard time writing a formula to get the output I am looking for.
Any help would be appreciated!
algorithms
asked Jan 7 at 18:33
Numb3ersNumb3ers
425
$endgroup$
$begingroup$
You are in the wrong forum for this question, but look up countif, maxif etc.
$endgroup$
– user121049
Jan 7 at 19:40
add a comment |
$begingroup$
I have 2 data sets, A and B. Each set includes an ID number, a QTY and a posting date. I want to quantify how many times an ID occurs in set A and how many times an ID occurs in set B after it has occurred in set A.
For example:
So we can see that ID 10000104400 has total quantity of -2 between 4/30/18 - 7/23/2018 and I would only care about what was adjusted in after these dates. So looking at Data set B I only care about the quantity of 1 on 9/26/2018.
I've tried using vlookups and sumifs but I am having a hard time writing a formula to get the output I am looking for.
Any help would be appreciated!
algorithms
asked Jan 7 at 18:33
Numb3ersNumb3ers
425
$endgroup$
I have 2 data sets, A and B. Each set includes an ID number, a QTY and a posting date. I want to quantify how many times an ID occurs in set A and how many times an ID occurs in set B after it has occurred in set A.
For example:
So we can see that ID 10000104400 has total quantity of -2 between 4/30/18 - 7/23/2018 and I would only care about what was adjusted in after these dates. So looking at Data set B I only care about the quantity of 1 on 9/26/2018.
I've tried using vlookups and sumifs but I am having a hard time writing a formula to get the output I am looking for.
Any help would be appreciated!
algorithms
algorithms
asked Jan 7 at 18:33
Numb3ersNumb3ers
425
asked Jan 7 at 18:33
Numb3ersNumb3ers
425
asked Jan 7 at 18:33
Numb3ersNumb3ers
425
asked Jan 7 at 18:33
Numb3ersNumb3ers
425
asked Jan 7 at 18:33
Numb3ersNumb3ers
425
425
$begingroup$
You are in the wrong forum for this question, but look up countif, maxif etc.
$endgroup$
– user121049
Jan 7 at 19:40
add a comment |
$begingroup$
You are in the wrong forum for this question, but look up countif, maxif etc.
$endgroup$
– user121049
Jan 7 at 19:40
$begingroup$
You are in the wrong forum for this question, but look up countif, maxif etc.
$endgroup$
– user121049
Jan 7 at 19:40
$begingroup$
You are in the wrong forum for this question, but look up countif, maxif etc.
$endgroup$
– user121049
Jan 7 at 19:40
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "69"
};
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
},
noCode: 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%2fmath.stackexchange.com%2fquestions%2f3065319%2flooking-up-data-based-on-dates-in-excel%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 Mathematics Stack Exchange!
- 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.
Use MathJax to format equations. MathJax reference.
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%2fmath.stackexchange.com%2fquestions%2f3065319%2flooking-up-data-based-on-dates-in-excel%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
$begingroup$
You are in the wrong forum for this question, but look up countif, maxif etc.
$endgroup$
– user121049
Jan 7 at 19:40