Ask Experts Questions for FREE Help !
Ask
    priesm2's Avatar
    priesm2 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Oct 6, 2010, 10:48 AM
    Matching data in Excel
    I currently have 2 different tables. One has a list of customers and their locations, and the other has a list of customers and how much product they ordered over the year. Not all customers made orders throughout the year. How can I match up the customers with how much they ordered?

    Thanks!
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Oct 7, 2010, 07:01 AM

    The functions COUNTIF() and SUMIF() will most likely be what you need to use.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Exporting data from one excel to another [ 13 Answers ]

I have a excel workbook containing 20,000 rows of data. I will have to develop a macro to copy a certain range of data from that excel workbook & paste the same in another excel workbook, rename the workbook & save. Suppose one column contains certain rows with values as 1, next set of rows as...

How to group data in excel [ 3 Answers ]

hi everyone. Got one big question. here goes: how can I group data in excel, from one speadsheet that acts as data column then putting the result to other spreadsheet. For example, spreadsheet 1: one column there contains "developer' or "designer" spreadsheet2: must contain all the names...

Preparing charts using excel data [ 2 Answers ]

Please help me Whether there are any softwares available on the web to prepare detailed charts/graphs showing x and y axis using data stored in MS excel/XML spread sheet? The chart/graph so prepared must be available for detailed analysis and viewed on a full screen! Thanks in Advance!

Data cleansing in excel [ 1 Answers ]

Every day I get reports of more than thousand rows for data cleansing. In that report mainly we have to delete all the related records as per amount like +100 and -100 should be deleted. I have attached the sample report here for your reference.

Shortcut for entering data in Excel [ 2 Answers ]

I often work with data in scientific notation. Is there a shortcut for entering numbers using only the number section of the keyboard? (i.e. entering 1.7E+09 without using the ‘e’ character)

View more questions Search