googlesheet

  1. Q

    How to create bar graph

    hello all, I would like to create a bar graph with percentage for how percent of classroom to dept. also, i like my dept to be my x axis. Class IDs Place Duration Dept 12345678 firstfloor 30.98333333 Math 12345679 secondfloor 45.15 Math 12345680 secondfloor 33.3 Math...
  2. T

    Googlesheet - How to skip empty cell in macro loop and continue filled cell?

    Hi, would greatly appreciate if anyone is able to help! I am working on editing a macro that involves vlookup copy/paste data from Worksheet A (IB) to Worksheet B (Inbound POs). However, it copies empty cell in Worksheet A and overwrites the filled cell in Worksheet B which i do not want...
  3. C

    SUMIFS having dropdownlist of expenses and income by month

    I have a problem with my sumifs I want to sum a specific dropdownlist and sum the whole month this is my code. C - Amount B - Dropdownlist (Expensive and Income) A - Date E - Months =SUMIFS(C2:C7,B2:B7,F1,A2:A7,">="&E2,A2:A7,"<="&EOMONTH(E2,0)) please help me with this if there is another...
  4. N

    If Statement Returning a 0 in Google Sheets but Calculates Correctly in Excel

    We have a bunch of raw data dumps with sales info and I am trying to build a breakdown so we can determine how much of each products monthly sales were organic versus email promotion versus rebates, etc. So you can see the image above. The if statement goes like this: If BreakDown="units"...
  5. R

    VBA to link googlesheet with Excel pivot

    Hi Guys, this is my first post and I have always found this forum helpful for my excel queries, I need to know if there is any possibility to connect my excel pivot with Googlesheet?
  6. S

    Questions on Importrange

    1) Why isn't my 'importrange' working on Google sheet? The sheet does not update itself automatically. Sometimes it works, sometimes it doesn't. What are the possibilities of fault? 2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet...
  7. J

    GoogleSheet - Trying to use nested MATCH inside VLOOKUP

    Hi All - I am trying to use "Match" inside a "Vlookup" for the Index input on the "Vlookup" formula. I am trying to pull "Estimated Hours" from one spreadsheet to another spreadsheet using "Work Order ID" as the ID> Work Order Log to Work Order Log - Rollup Spreadsheets...

This Week's Hot Topics

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
Top