google sheet formula

  1. A

    Function to return value based on conditions

    Hi currently, I am using google sheet I want to use a function to satisfy the following conditions. the values of cells range A3:L19. the values of cells range A1:L1. the values of cells range A22:L22. if there is data (Text OR Number value) in the range (A3:L19) OR the values of range A1:L1...
  2. N

    Google Sheets - Index, Match, & Importrange - What is wrong with my formula?

    These are two example sheets of what I am trying to do: Reference: Reference Sheet Summary: Summary Sheet I am trying to pull information from the Reference sheet into the Summary sheet. I want to pull based on the zip code I enter into the Summary sheet, cell B2, from the row matching that...
  3. K

    How to extract partial data from one sheet to another using a single formula in Google Sheets

    Before I start, here's a copy of the sheets I'm using: Here's a copy of the sheet I'm using: https://docs.google.com/spreadsheets/d/1Y079euBk63RYcgFOPjBFwMlPi53SUAIgZ-h69_o9Hsc/edit?usp=sharing I have two sheets, Expenses and Tax Deductibles. The Expenses sheet has it's data filled via a Google...

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