I am the person that will be helping you today. May I take a look at the document in question along with a more elaborate description of what needs to be done?
Please, be forewarned that the site is not secure:- Click the following link: http://www.wikisend.com- Upload the file to that website- Once it is uploaded, the resulting page will display a "File ID" number.- Please, give me that "File ID Number" I will be standing by, looking forward to your response.
I have the document. Please, walk me through all what you need for me to do on this document.
I am sorry to say, but I don't understand what you want me to do in the document. Please, give me examples.
Okay. Please, give me examples of what you need the "Formulas" to do. Which values will they take into consideration and what will be the end result.
Please, understand that this is the first time I have seen your layout of the document.
When you say that you "....need the formula to consolidate/group the orders and demand by state...", what does that mean?
When you say that in the second tab you "need the formula to populate what is in the two tables into a third...", what does that mean?
I'm sorry, but I don't understand.
I wish I could answer your question, but I don't understand what the question is.
For this reason, I am opting out of the question and allowing another expert the chance to help.
The next expert will see all that is on this page, so there will be no need to repeat anything.
When another expert picks this up, you will be notified by email.
Thank you for your patience.
I made an attempt to provide the first answer in this version of your document:
You'll see that I used the SUMIF formula to compute the numbers. To generate the list of unique states, I used a one-time advanced filter/copy step, which doesn't show up as a formula in the second table, but I can show you how it was done.
Before continuing, I just wanted to run it by you to see if we're on the right track and to confirm you're still interested in the 2nd part.
Glad to hear it!
Here's my approach to the 2nd part - updated workbook:
A few notes:
- the key function you were looking for is VLOOKUP
- It happens to work out nicely because the list of customer IDs in table 1 and 2 are the same. So I just copied that column verbatim to table 3, and then filled in the VLOOKUPs to pull the corresponding cells from Table1 & 2. If you were to have different lists of customer IDs in table 1 & 2, things would get more complicated.
- your table 3 currently has an extra "header" row that's considered part of the data rows, so if you sort the table, that row gets moved around. YOu probably want to delete that row or make it the official header row of the table instead of the generic "ColumnX" names.
Hope that helps!
Hi,just following up, were you able to use my solution? Please feel free to post any additional questions, comments or concerns you may have regarding this issue.
If you're not yet satisfied with the result, please let me know what is missing. I will do my best to make it right for you.
Otherwise, please don't forget to rate my service - I don't get paid for my work until your rating is received.