I have found various posts that merge/consolidate data, but have found the correct for my particular issue.
I have two ranges that contain to and from dates and a corresponding value. I need to consolidate them into one list with consolidated totals.
Manual output required in Col J-N
Inputs A-C, E-G
Any help would be appreciated.
Hi and welcome
A couple of clarification questions for you:
1) Would there only ever be two tables that need combining?
2) Are the table lengths (number of rows) variable?
BSB
Hi There would only ever be two tables......and the data would never go beyond 50 lines.
Thanks
I don't understand why cell J7 displays 7/28/2024. I don't see that date in columns A:B nor E:F
I also don't understand why cell K8 displays 7/22/2014 as a (apparent) end date for 4/1/2014. It seems the end date in cell K8 should be 12/31/2014.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
To Add some context, the two sets of data are employment details relating to how many hours per week the person works. During the corresponding data range In this example two part time jobs.
I need to merge the date and data together to get one set of data.
I think your sample could be modified as attached picture.
Try this formula, this requires GROUPBY function, please check update if #NAME error.
Please Login or Register to view this content.
Last edited by RhiSJ; 11-25-2024 at 10:15 AM.
You made my day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks