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

Hi!
I have 2 data sets.
The first data set is the big one w/ thousands of entries and several columns.
The second data set is the smaller one with three columns of info from the big data set. There are a hundred entries.
The small data set has select account IDs that correspond to Associates. Some Associates service multiple account IDs and therefore have multiple account IDs corresponding.
The big data set has thousands of entries. Though each entry has a corresponding account ID, there are several orders, so account IDs may have several entries.
I'm only concerned with the account IDs and Associates of the small data set even though the big data set has all account IDs and Associates orders.
I am looking for a way to filter out or generate all the entries in the big set that fit certain criteria. However, this criteria is linked, so all the entries that have A and B criteria in respective rows.
I narrowed the list of orders from Associates with specific orders and have the Small set showing the account IDs, associate, order, date.
I need to go to the big list of all orders and now find all entries with order equaling - product A and on date - X. So only the entries with both product A and date X. Not either or, both criteria must be present.
To do so, I have used VLOOKUP to get the initial list of what all orders made from the small sets associates and found the orders and corresponding dates I'm concerned with.
Then I Went to the big list and tried to use filters to find entries with product A done on on date X.
What would you suggest?

Solved by V. E. 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

im trying to insert an object in to a spreadsheet. the documents im moving is an excel file. t was working fine the other day and now it is not. Every time i try to inset an object itll put a small empty box in the top left corner. Also im clicking the link topage because if i dont the document shows up cloudy. I really dont know where to begin. Im attaching the spreadsheet i have to add the documents to.

Solved by I. Y. in 25 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 am trying to fill small tables from a master data table, I am trying to use the vlookup but it doesn't seem to work as well for this as I thought it would. Could you take a look at this file and see if you have any suggestions?

Solved by Z. W. in 12 mins

Hello, I need a small help is there a quick way to add 2 cells together ex a1 + a2, a3+a4, a5+a6, a7+a8 etc. I'm not that good with formulas and have been trying to see a quick way to do this as well since I have close to 700k+ entries to do. Any advise and help would really help out. thank you

Solved by Z. H. in 25 mins

Hi we are a very small company in the care industry - we use an audit spreadsheet but are struggling with graphs and charts - we have had quotes for this but way too expensive for us - any recommendations
thanks

Solved by G. F. in 22 mins

I have created a small test sheet to check that the INDEX MATCH formula is working as I need it to.
It seems to mostly work but randomly returns the wrong postcode for a couple of rows.
I have highlighted this postcode in yellow on the lookup column and in green on the return column.
This should match without issue like the other values that work fine (I dragged the formula down from D2).
But for some reason the wrong postcode is being returned (highlighted in red).

Solved by A. H. in 12 mins

Play with different values for the Average Annual Return and see how a small change in the rate can have a big effect on your return. Over 30 years, the average inflation-adjusted returns for the S&P 500 have been between 5–8%. Use a lower percentage to be more conservative in your calculations. This would move you toward over-saving rather than over-estimating and being caught short at retirement.

Solved by F. L. in 13 mins

how to split a text value like "1/2" to populate into phrase "Holds 1 large, 2 small Suitcases"

Solved by X. C. in 26 mins