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!

[REPOST] 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 A. S. in 46 mins
I need to count unique, non-numeric values from a dynamic column.
Solved by D. L. in 16 mins
I have a very large excel spreadsheet consisting of copious amounts of data. To make a really long story short, I need to eliminate all single values in one particular column in my spreadsheet. By "single value" I am referring to single letters, such as "A", "B", "C" etc. These are the middle names of the spreadsheet, and I need to get rid of them for a specific column. Because there is so much data, it is unrealistic for me to do this manually. These single value letters are in the same column as regular word values with full last names, so I can't just delete the entire columns without getting rid of the regular names that I want to keep. So is there any kind of Excel function that allows me to delete the single values only? Thanks.
Solved by Z. D. in 18 mins
I am having issues creating the one way data table to show the means and standard deviations when you change the proportion of portfolio 1. I have the mean formula and the standard deviation formula at the top and -1 through 1 down the left side. I highlight all of it and create a data table. I reference the "proportion of portfolio 1" cell in the column input box but when the data table comes out it has all the same numbers all they way down the table.
Solved by G. Q. in 49 mins
I need to analyze data in this file. Companies’ column A and part in column F. Which companies have both Part A and Part B, Which have only Part A, which have only Part B. Top 10 Part A companies.
Solved by Z. E. in 20 mins
I have a column containing date and time data together and i need to isolate the time data. When I tried to use text to column, it changed all the times to AM. There is an extremely large amount of data - over 550,000 rows so manually changing it won't work. The file is too large to attach.
Solved by S. E. in 40 mins
Greetings, I am trying to find a formula in excel that will return the number of students attending courses. My data is on one sheet and my report will be on another sheet. The report is formated with the students list in a coulmn (far left), the courses are list in a row (top). My data is formatted with all columns, courses in column in "A" and students in column "B". Thanks
Solved by E. C. in 27 mins
indexing multiple rows of data from criteria in a column (need to be able to bring up multiple job specifics [each job has its own row] by searching in the "due date" column for jobs due between start date and end date
Solved by O. S. in 55 mins
i need to compare numbers in 2 columns 400+ lines and have it report either 'in' or 'out' based on the outcome of the comparison of the two formulas. one is a signed out column abd the other is the products that are returned
Solved by G. L. in 11 mins
how to paste a formula from one column to another
Solved by E. E. in 20 mins
1 2 3 4 5 128 129

Click here to get your free Excelchat help session

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc