Get instant live Excel expert help to learn how to use Large function?

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a large set of data (40k entries). The columns include Account ID, Associate, Order Description, Date and Time. There are several Account IDs. Each is linked to one Associate. However, the Associates have various Account IDs to service. I need to generate a report/export data/filter out all the entries that have given criteria. The tricky thing is my criteria list is also rather long. I have about 100 total possible conditions, so I need all entries that have a given Order Description AND a specific order date. There are 100 totals sets of criteria. What would you advise would help me do this? How do I filter with many conditional filters? It isn't as simple as clicking the filters I want from each column because 1. the column value must also go with another column value and 2. There are so many possibilities. Ie. I don't want to generate a list of all orders with Order Description - blueberries, oranges, apples, etc. I want to generate a list of all orders with Order Description blueberries on March 1, 2016, oranges on April 3, 2017, oranges January 5,2017, apples March 10,2017.
Solved by F. F. in 19 mins
every month I get a very large list of recalls. and most of the time it is the same vin numbers from the previous month. is there any way I can have the previous month selected and if there is a duplicate of the vin then to copy it onto my new month sheet?
Solved by C. B. in 20 mins
I have a very large list of data on individual members. This data includes each person's Federal District, City, and State. I want to count the number of people who live in each Federal District, City, and State. Attached is a very small version of that list. I have already used Advanced Filtering to create a list of every unique Federal District, City, and State. I am trying to figure out the Excel formula to count all the entries. It is easy to count individual entries from one row (i.e., all cities), but that is not helpful because some city names are duplicated in other states.
Solved by O. B. in 17 mins
i am trying to create a macro or vbo that can look at a large list, see if one line share common with another and input that data in a different column
Solved by C. H. in 30 mins
Having an issue with our spreadsheet. The Summary Tab and Expenses per Department tab both show different totals. Also, would like a second set of eyes on the formulas but the non-matching totals are the large issue.
Solved by S. J. in 13 mins
I have a large spreadsheet, 3000 or so rows. In one column I have company names, the first row has information about that company (address, phone number), followed by rows for every purchase made by that company and for how much. Is there a way to automatically apply the company information on the first row to each subsequent rows listing the purchases?
Solved by V. D. in 20 mins
I need help doing these assignments. On the Dashboard, create a drop-down list that allows you to select one of the item numbers. On the Dashboard, design and create a well organized section that summarizes all of the "Item Data" for the part selected in the drop-down list. The information should update when the part number is changed. The information in this section should reference the data found in the "Item Data" sheet. In the top portion of the Dashboard, create a large title block (which is one large set of merged cells). In the title block, report the following in one cell, with the description all in capital letters, and with the parenthesis also shown:
Solved by T. Y. in 21 mins
i am trying to create a macro or vbo that can look at a large list, see if one line share common with another and input that data in a different column. so i need a macro that will look at column b and identiy all "parent matrix item" for example on this sheet,line 2 - item 1389 is parent matrix item and is null for column d. line 3 is parent item for lines 4-9. they care called child matrix items. i need whatever is in column d for the child matrix items to be inputed into the corresponding parent. parents are not always on top of children either
Solved by E. F. in 24 mins
I want to make a sheet where it tells a person what shipping method they need, so they would fill out the height width weight and price and then the formula would know whether it was for example a small parcel or large parcel, whether to send it first or second class and if it needs to be signed/tracked or not.
Solved by T. Q. in 26 mins
I have a complicated SUMIF problem I think: I want to sum the values in a column only if in 2 other columns, numbers match each other. I.e. if value in A2 matches A3 AND value in D2 matches D3, I want the sum of numbers in C1:C4 added. I've uploaded version of spreadsheet with all columns but with most of the records deleted (it's a large file with >100k records). In my spreadsheet, I want column FK to add up the numbers in column ES only when the values in column A match each other and the values in columns DN match each other.
Solved by E. H. in 19 mins