How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1293
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I have a table with 9 columns. The first four are text and

Resolved Question:

I have a table with 9 columns. The first four are text and the last five are numeric.

I'd like a formula that checks the first four columns for rows that exactly match in those 4 fields, and then combines the values in each of the numeric columns.

Is that possible?

Thanks!

I don't have much excel experience.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 1 year ago.
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

Is this question a duplicate of the other excel question you asked from the following url?

http://www.justanswer.com/microsoft-office/7sq6b-need-help-i-d-formula-checks-field-column.htm

or are you looking for a different formula here.

Please let me know how you wish to proceed and I will be happy to assist
Customer: replied 1 year ago.

Thanks for checking. This is not a duplicate, although the idea is similar.


 


What's different about this question is i want to combine values in each of 5 columns, when values in each of four columns are identical.


 


The other question only checked values in one column, then combined values in another single column.


 


Like the other question, however, I'd like to not have to type in each value that I want to match. I just want it to find matches itself. There are so many rows that having to redo the forumla for each value would mean I'm not saving much time.


 


Thanks again.


 

Expert:  The-PC-Guy replied 1 year ago.
ok, I posted a response for the other formula.

Please let me know that the other formula works for you.

Then please rate the other question so I am reimbursed for my time.

I will be happy to look at this more complicated formula.

However given this more complicated. I would need a copy of the sheet you are working on, or an example, if you don't want to share the exact information.

Please upload to

www.wikisend.com

after uploading you will be given a download link

paste that link here.
Customer: replied 1 year ago.

Thanks. Here's a sample from the file. The actual file has 245,343 rows. That's why I don't want to have to enter in each individual group of values to match.


 


http://wikisend.com/download/388490/for the-pc-guy.xlsx

Expert:  The-PC-Guy replied 1 year ago.
ok thanks. It is getting late where I am. If you could wait until tomarrow, I will take a look then.
Customer: replied 1 year ago.

that's fine. sleep well.


 

Expert:  The-PC-Guy replied 1 year ago.
I donwloaded the sheet, Can you please explain to me exactly what you are trying to accomplish?
Customer: replied 1 year ago.

Sure. The end result I want is for rows 2 to 5 to be combined so that I have one row for "Costa Rica, Costa Rica, Costa Rica, Alajuela."


 


The same for rows 7 to 11.


 


The same for rows 12 and 13.


 


The same for rows 13 to 18.


 


I've got almost endless rows like this, and I hope Excel will be able to combine those rows that are duplicates in columns A to D.


 


Thanks!


dave

Expert:  The-PC-Guy replied 1 year ago.
maybe something like a pivot table would work for you.

it takes a little while to understand how the data is being presented. But once you do it is aggregated for you.

I am not even sure if MAC supports pivot tables.

look at the modified example to see sheet 2. If you see the pivot table you can click on it to see how its set up.

If MAC does support it, all you would need to do is set up the 9 columns in the appropriate places. The first 4 columns would go under row headings, then you would need to set the other 5 columns to sum(values) under the values box.

Let me know how it works out, or if you can even view the pivot table in sheet 2.

http://wikisend.com/download/732484/for the-pc-guy-exp.xlsx
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1293
Experience: 20 years experience providing remote computer support
The-PC-Guy and 2 other Microsoft Office Specialists are ready to help you
Customer: replied 1 year ago.

Thanks. I'll check it out. I have been told I can do pivot tables on a Mac, but I've never actually done one.

Expert:  The-PC-Guy replied 1 year ago.
well if you run into trouble, ill try to help you create one.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions