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!
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