Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

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 30 mins
in column a i want to input 1 2, 1 3, and then drag down to get 1 4, 1 5, 1 6,,.....and so on. I want to do the same for 2 3, 2 4.
Solved by Z. C. in 20 mins
I have 2 sheets. One sheet with the demographics of contractors. eg. Company A, Hispanic, Male. In the second sheet I would like to be able to choose the company from a drop down menu (listing all companies) in column A and have columns B and C automatically populated with Hispanic and Male.
Solved by A. Y. in 34 mins
I have a Heading Title at the top of each column and keep my tally (formula) of that column in the second row. However, ever time I sort/filter my worksheet the second row also gets sorted and I lost my tally - which I use for analysis in the second sheet. I have tried freeze and split and neither works. Please help !
Solved by F. Q. in 40 mins
I need assistance with combining sumifs and indirect. I want to find the worksheet with the same name as cell E14 and get the sum of the column titled "Login Defects".
Solved by D. D. in 22 mins
Hi, I have a list of names in 1 column, with title, company, etc in a row and each person has multiple emails. Each different email is in a different column. I want to copy each row and align each different email so the email is in the same column with name, title etc repeating.
Solved by F. D. in 60 mins
I have a row of numbers in column B. I want to divide all those numbers by 2.2 in column C. Please help - I am 78 and have forgotten how to do it!
Solved by G. L. in 59 mins
I have a workbook that is made up of 4 worksheets: ALL, Approved, Denied, Completed Essentially, in the ALL Worksheet, column K has Decision (Approved, Denied), I would like to move all with Approved to the Approved Worksheet and Denied to the Denied worksheet. ONce moved, I would like the rows to move up so their aren't blank rows. Also, on the Approved worksheet, there is a column M for Status. Once completed is selected in Column M, would like to move from Approved Worksheet to Completed Worksheet
Solved by I. U. in 31 mins
Trying to figure out what is wrong with my formula in Oct-ZD tab in column AY and BG.
Solved by O. Q. in 8 mins
I want to replace entire column............................................
Solved by B. B. in 40 mins
1 2 128 129