#googlesheets

  1. K

    formula on google sheets

    what is the formula on google sheets for : I have 3 columns A,B,C highlight if sum of column a and b doesn't equal column c.
  2. A

    Importhtml() on google sheet converted data to a different format

    I have sport data that I imported from an api There is a particular column named G in which, two data are combined and partitioned with a colon ( : ) (attached is the pic) So when the column is imported into the sheet, it changes format to hh:mm:ss (time format) e.g 56:45:00. Kindly check...
  3. A

    Excel + Google

    Hi Everyone I wanted help finding the number of Google search results for each keyword/Box. For example: Google search results for these keywords are: Football: 3,920,000,000 results Beauty: 6,470,000,000 results Cinema: 2,870,000,000 results What I need is a formula that provides me with these...
  4. E

    Combine COUNTIF, OFFSET and SUM in GoogleSheets

    Hi i have a few questions, i try to make advanced formula but still without succes, so i decide to post here. At first im looking for a data in different TAB which i will write a formula. Searched Tab is 'Match History' Result Tab is 'Players' What have i done? Counting the number of...
  5. E

    importxml or any similar formula

    Hi friends, I need some help with this formula... I have been following the steps direct from the google helps and lots of tutorials but I cant see results... I have a google spreadsheet, and a I have an inventory app (website) so I need the info of this app in one of the windows in the sheet...
  6. P

    Excel Import from Web Google sheet to Excel Arrayformulae issue

    Hi, I have an excel sheet , on which I use "import from Web" ( Google Sheet ). For past couple of days, some values are missing on the excel sheet.. I was able to figure out that the missing values are ones that are generated (in google sheet) as part of an Arrayformula . for example, in column...
  7. C

    Google SpreadSheet Macro - Script Editor

    Hello everyone! I am intending to hide specific columns such as column B,E,G. Also, to unhide it again if its hidden. So my intention is to create a button that when pressed, it first hides those specific columns, and if i were to press it again, it will unhide those hidden columns, and vice...
  8. B

    Vlookup when the names don't match

    Wow trying to put a title to this was hard. So here is the issue and I have been racking my brain to figure it out and I am at a loss. I have a productivity report and I need to look up how many contacts the rep did from the previous day on a different tab. This Report is continually added to so...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top