Are you stuck on Excel or Google Sheets?

I need a formula to separate a date from a date/time column. 2017-04-02 12:06 +0000 to 2017-04-02

I need a formula to count cells with a value containing the word "arc" or the word "robot". The cells are all in the same column, but some of the cells contain both words so I get duplicates in my count.

The below data is in one column. How do I get the blank cells to Auto Fill from what is in the cell directly above it ? ABO & Rh Blood Type ABO & Rh Blood Type ABO/Rh Blood Type Varicella Zoster Antibody IgM Varicella Zoster Antibody IgG Varicella Zoster Antibody IgG Varicella Zoster Antibody IgG HbA1c

I want to know how to filter out duplicate data in a column in excel

I need to automatically extract a sheet from muliple workbooks into a combined workbook with all sheets. Then I need a formula to add up each column from all the sheets

I need to copy a column with some blank cells to another column with some blank cells, but without replacing the other colums that have data in them.

I have created a new column in which I need to automatically show either "yes" or "no depending on whether the value of a previous column has a number less than or greater than 2000.

I have 10 groups of 10 names in a column, and need a formula for Excel to output a name when someone randomly chooses first a group, and then one of the names in that group, but does both things at the same time

Hi, I am trying to find an average of one column 'C', where another column = a particular value, or a third column = another particular value.

repeat equation with different values of x until y =0. y=(3x^4 -235x^2 -12.5x +10124). Can this be done with a single formula rather than dragging out a column