Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to combine two separate reports and add them together to match up certain common criteria. I would like to make a third sheet using the matched up unit numbers and amounts from both reports and label them appropriately with the deposit number from sheet 2, and if possible add the deposit date from sheet 2 as well.
Solved by M. J. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
13/07/2018 - 07:43
Hello?
Excelchat Expert
13/07/2018 - 07:43
Hi
User
13/07/2018 - 07:43
I have only 20 minutes on the clock, and need help lol
Excelchat Expert
13/07/2018 - 07:43
Sure, please provide details about the problem
Excelchat Expert
13/07/2018 - 07:44
You have an option to extend the session also
User
13/07/2018 - 07:44
I have two separate reports that are grouped differently the only common factor are amounts and unit numbers but I dont know how to create a new report or combine the two to be grouped together so they match up
Excelchat Expert
13/07/2018 - 07:44
Can I see the reports, it would help me understand more accurately and provide better solution
User
13/07/2018 - 07:45
ok there they are
Excelchat Expert
13/07/2018 - 07:45
Yes
User
13/07/2018 - 07:46
if at all possible i would like the out come to also match up the deposit number from report 2
User
13/07/2018 - 07:46
can you see the reports?
Excelchat Expert
13/07/2018 - 07:47
i can see only one report in sheet 1
Excelchat Expert
13/07/2018 - 07:47
sheet 2 for me is blank
User
13/07/2018 - 07:47
i added it in
User
13/07/2018 - 07:47
i dont know why its not showing
Excelchat Expert
13/07/2018 - 07:48
Now its showing
User
13/07/2018 - 07:48
i will try and figure it out, but i am looking to match unit numbers and amounts and be grouped by deposit number from sheet 2
Excelchat Expert
13/07/2018 - 07:49
So based on units, amount and date you want to combine the data
Excelchat Expert
13/07/2018 - 07:49
Is my understanding correct about the problem?
User
13/07/2018 - 07:50
yes but not the dates, the dates will not alway match
Excelchat Expert
13/07/2018 - 07:50
okay
User
13/07/2018 - 07:50
I am looking to match up units and amounts and then group the whole thing by deposit number on sheet 2
Excelchat Expert
13/07/2018 - 07:51
So, if i can get deposit# in the sheet 1 (separate column) will that work
User
13/07/2018 - 07:52
yes i suppose
User
13/07/2018 - 07:52
as long as the correct deposit number gets added to sheet one, the reports have a lot of different information, not all entries are the same
Excelchat Expert
13/07/2018 - 07:54
give me few minutes while I work on it
User
13/07/2018 - 07:54
thank you
Excelchat Expert
13/07/2018 - 07:59
Also, is it possible that not all values in sheet 1 are found in the sheet 2?
User
13/07/2018 - 07:59
correct
Excelchat Expert
13/07/2018 - 07:59
Here it is
[Uploaded an Excel file]
Excelchat Expert
13/07/2018 - 08:00
I used Vlookup function to get the deposit# in Column N sheet 1
Excelchat Expert
13/07/2018 - 08:00
Have a look
User
13/07/2018 - 08:01
It looks like what I need but wont know for sure until I start ticking and tying out these items. Is there a way for me to now organize them by deposit number?
Excelchat Expert
13/07/2018 - 08:02
Yes, sorting
Excelchat Expert
13/07/2018 - 08:06
Here's the sorted file
[Uploaded an Excel file]
User
13/07/2018 - 08:07
was that in sheet one or two?
User
13/07/2018 - 08:07
sheet two looks like how i sorted it
Excelchat Expert
13/07/2018 - 08:07
sheet 1
User
13/07/2018 - 08:07
thats what i meant sorry
User
13/07/2018 - 08:07
ok, thank you for your help!
Excelchat Expert
13/07/2018 - 08:08
This solves your problem?
User
13/07/2018 - 08:08
Again I wont know until I spend much more time looking at it. but thank you
Excelchat Expert
13/07/2018 - 08:09
You are Welcome
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.