How to select next greatest Date based on customer match in EXCEL?Moving to the next line of data when the...
Why did Ylvis use "go" instead of "say" in phrases like "Dog goes 'woof'"?
What makes papers publishable in top-tier journals?
Sharepoint metadata URL
Boss asked me to sign a resignation paper without a date on it along with my new contract
Can you determine if focus is sharp without diopter adjustment if your sight is imperfect?
Is there a verb that means to inject with poison?
The No-Straight Maze
Are the positive and negative planes inner or outer planes in the Great Wheel cosmology model?
How vim overwrites readonly mode?
A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?
Charging phone battery with a lower voltage, coming from a bike charger?
How do I avoid the "chosen hero" feeling?
How to write cases in LaTeX?
Website seeing my Facebook data?
Stuck on a Geometry Puzzle
What natural barriers could help when running away from a lightning elemental?
Reading Mishnayos without understanding
How to politely refuse in-office gym instructor for steroids and protein
Need help with a circuit diagram where the motor does not seem to have any connection to ground. Error with diagram? Or am i missing something?
Does the ditching switch allow an A320 to float indefinitely?
Does diversity provide anything that meritocracy does not?
Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?
Non-Cancer terminal illness that can affect young (age 10-13) girls?
How do you get out of your own psychology to write characters?
How to select next greatest Date based on customer match in EXCEL?
Moving to the next line of data when the date changesHow to check if a date is within a given range in Microsoft excelExcel Formula for Sum of hours based on date selectedExcel formula to calculate sums of a row across more than 1 tab (different names), based on dateExcel 2013 - select a date range and filted by agentexcel, find last previous dateCalculate the number of days per year between two different dates ExcelExcel - Date detection/comparison in mixed format cellsCalculate date when age plus service equals specific value in ExcelFormula based around dates
I need a formula to pull in the next greatest date based on customer match from a another set of data.
So on one tab I have Customer JOE who has a service date of 1/1/19. On another tab is all service dates JOE had ranging from Dec 2018-Feb 2019. I need to pull in the next service date after the 1/1/19 from the original tab
microsoft-excel
New contributor
add a comment |
I need a formula to pull in the next greatest date based on customer match from a another set of data.
So on one tab I have Customer JOE who has a service date of 1/1/19. On another tab is all service dates JOE had ranging from Dec 2018-Feb 2019. I need to pull in the next service date after the 1/1/19 from the original tab
microsoft-excel
New contributor
add a comment |
I need a formula to pull in the next greatest date based on customer match from a another set of data.
So on one tab I have Customer JOE who has a service date of 1/1/19. On another tab is all service dates JOE had ranging from Dec 2018-Feb 2019. I need to pull in the next service date after the 1/1/19 from the original tab
microsoft-excel
New contributor
I need a formula to pull in the next greatest date based on customer match from a another set of data.
So on one tab I have Customer JOE who has a service date of 1/1/19. On another tab is all service dates JOE had ranging from Dec 2018-Feb 2019. I need to pull in the next service date after the 1/1/19 from the original tab
microsoft-excel
microsoft-excel
New contributor
New contributor
New contributor
asked 5 hours ago
JillianJillian
1
1
New contributor
New contributor
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:
=INDEX(dates,MATCH(A1,dates,0)+1)
Just adjust the ranges as needed
(Note: I have dates
as a named range, column D (and this goes all the way to 2/28/2019
)
add a comment |
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
});
}
});
Jillian 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%2f1409248%2fhow-to-select-next-greatest-date-based-on-customer-match-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:
=INDEX(dates,MATCH(A1,dates,0)+1)
Just adjust the ranges as needed
(Note: I have dates
as a named range, column D (and this goes all the way to 2/28/2019
)
add a comment |
Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:
=INDEX(dates,MATCH(A1,dates,0)+1)
Just adjust the ranges as needed
(Note: I have dates
as a named range, column D (and this goes all the way to 2/28/2019
)
add a comment |
Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:
=INDEX(dates,MATCH(A1,dates,0)+1)
Just adjust the ranges as needed
(Note: I have dates
as a named range, column D (and this goes all the way to 2/28/2019
)
Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:
=INDEX(dates,MATCH(A1,dates,0)+1)
Just adjust the ranges as needed
(Note: I have dates
as a named range, column D (and this goes all the way to 2/28/2019
)
answered 2 hours ago
BruceWayneBruceWayne
1,8771721
1,8771721
add a comment |
add a comment |
Jillian is a new contributor. Be nice, and check out our Code of Conduct.
Jillian is a new contributor. Be nice, and check out our Code of Conduct.
Jillian is a new contributor. Be nice, and check out our Code of Conduct.
Jillian 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%2f1409248%2fhow-to-select-next-greatest-date-based-on-customer-match-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