Hi, I have a google spreadsheet and all the columns are continuously updating based on the website values. Is there a way to record the highest value that a cell had during all this time/for a particular period? It is like recording the last 24 hour high for financial markets. Thanks
2. ### Date diff with multiple conditions

Hi, Currently I am computing the date difference in days using this formula (which works): =if(and(ISNUMBER(W2),ISNUMBER(H2)),W2-R2,"") However, I would like to restrain the output and only consider values between 5 and 150. So I would like the function to say If W2 isnumber and if H2...
3. ### Is it possible to build such a application using Microsoft Excel or should I stick to googlesheets?

For a personal project, I am trying to build an application for data collection. This is the idea for the application 1. The user enters data into the spreadsheet template using either an android mobile phone or chrome browser 2. Each week, the user creates a new spreadsheet from the...
4. ### Google Sheets SUM + CountIfs formula not working

I'm using Google Sheets and am trying to get this formula to work to give the me the following count: Count when Column T = Kenneth AND Column U = (Pending OR Contacted) AND Column W has a date that falls between the dates shown in B14 and B15. This is what I have so far...
5. ### Run Google Script through last row only?

Hey guys, I'm running an email script which works fine but only want it to run through the last row with data in it. I don't need it or want it to run if there is no data obviously. How do I reflect that in the example script below? For example, say there are only 3 rows of data in my sheet...
6. ### Small Bug Fix to a Multi If Formula

Row B=Status (In Progress, On Hold, or Completed) Row C= Task Description Row D= Start Date Row E= Estimated Completion Date Row F= Actual Completion Date Cell I5=Date (Part of a series of dates within the calendar month) Current Formula...
7. ### Multi IF Formula within Single Cell

Hi, So, I'm creating a gantt chart in google spreadsheets and need to have bars fill in specific colors based on the start date, estimated completion date, todays date, and the tasks progress. In other words, I need the time between the start date and estimated completion date to be gray. As...

Hello all, This is technically not an Excel question but about Google spreadsheets because I know how to do this on Excel but it won't work on Google spreadsheets. I need to count all total instances of the word "Freelance" in a column A with a corresponding value of "London" in a column B...

Hello all, I have used quite a few COUNTIFS formulas in Excel that do not translate into Google spreadsheets. I was wondering if anyone would know how to translate the following formula into Google spreadsheets...
10. ### Can I identify a specific permutation of responses to a survey and display it?

I very much appreciate any and all help in accomplishing this objective as follows: I have an online survey which has 9 list box questions. The only options for each question is "A" or "B". When the form is submitted I will have one row with some "9 column permutation" of "A's" and "B's". Each...

Hi, Anyone heard of a decent way to import spreadsheet data from Google Spreadsheets into an excel document so the resulting excel spreadsheet has live updatable google spreadsheet data? Regards Steve Flavel Pharmacist from Queensland, Australia

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back