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!

All solutions
Hello! There is a column with a certain number of rows in it. I need to calculate two averages: the average of every second row starting from the 1st one (aka the average of every odd-th cell) and the average of every second row starting from the 2nd one (aka the average of every even-th cell). I got tangled up with =OFFSET... Thanks!
Solved by C. J. in 37 mins
I want a column to total all the black numbers in another column, not the red ones.
Solved by K. L. in 40 mins
I need a way to set a default Excel template which will open when ever I open excel. I have a preference for Date format, column and row structure, reference column and freeze panes that I use in almost all sheets. Currently I have to reformat each time I open a new sheet or else re-open a saved version. In prior versions of excel I was able to change the base template. That is my question.
Solved by I. J. in 40 mins
need help how to add a percentage to a column and subtract
Solved by B. U. in 43 mins
How do I prevent Duplicate entries in multiple columns in Excel using data validation in MSExcel 2016. I would like to prevent the user from data entering a code more than once in three column ranges
Solved by B. D. in 60 mins
How can I count the number of rows within a certain date range from a different sheet in a workbook? Similarly, can I sum the numerical values in one column within that date range?
Solved by A. C. in 13 mins
I need assistance setting up a time sheet formula where I can create a column of contiguous dates down the left hand side of the spread sheet. So I can copy a contiguous column of dates, rather than entering each date manually. I would only need to have work days in the list, ie Monday to Friday inc. with a couple of spare lines between each week.
Solved by Z. Y. in 40 mins
I have two columns with names and a third one with email addresses. For every name that matches, I need to copy the email address to an empty column next to the matching name. .
Solved by E. U. in 15 mins
On the sheet the named "Cycle Time", I need a formula in cell L3 that will search for the person's name in cell A3 in column P on the sheet named "Xactanalysis Raw Data" and return the earliest date in column Z of the "Xactanalysis Raw Data" sheet for that person's name back to cell L3 of "Cycle Time". I intend to copy this formula down the sheet.
Solved by G. J. in 16 mins
help me please. I am trying to narrow down a spreadsheet by amount and then also my column
Solved by F. A. in 60 mins
1 2 3 4 128 129

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc