google docs

  1. S

    Batch Data Import to Google Sheets

    Hi, Thank you very much for taking out time and trying to help me out. Here is what I am stuck with : 1. I have a list of around 4000 companies 2. Each of those companies have three financial statements (two of them enclosed for reference) 3. Therefore I have around 12000 sheets to work with...
  2. R

    Number Data Does Not Copy Correctly

    I have my data on Google Sheets, and I need it on MS Excel. Here is what I have tried. Copy and paste (multiple formats like number, plain text, HTML). I also copied and pasted it into an email and onto notepad. I also directly downloaded the file from Google Docs as an XLSX format, and that...
  3. M

    ipad download of excel spreadsheet; scanning a bar into a cell of spreadsheet; on the fly.

    I'm new to the forum. I'm hoping I can get some advice. I work in a showroom environment. I am barcoding every product in my showroom. I am using a vlookup command and loading information about each product into an excel spreadsheet. Using an ipad, I would like my staff to share this excel...
  4. P

    Extract email from url

    Hello guys, Does anybody know the formula to insert in Google docs to extract an email address from an url? So (column A) www.sitename.com | (Column B) email thanks
  5. C

    Using Time Range to Create Gantt Chart

    I'm trying to use if/and functions to create a gantt chart for a schedule. A person working from 8:00 am - 5:00 pm, where if its outside this time range its a 0, inside its a 1. Conditional formatting to do the rest. X axis is the day broken down into hours, y axis is the names of people...
  6. W

    Excel VBA to download Excel Google Doc

    Hello guys, I would like to have a code that can open my excel google doc, click file, choose download as, choose microsoft excel, click open. This process is identical for all Excel Google Doc, so I don't think I need to give my google doc website addresses. Can someone help me please? I...
  7. J

    VBA Conversion Question

    Not sure if this is the right section or even the right forum for this question but I hope someone here can help. I am in the process of moving a very useful Excel document that I created to Google Doc's. The problem is that it is useful because of the VBA Macros that I have built in it and of...
  8. T

    Google Docs INDEX MATCH formula not working

    Hi, I have transfer my excel file to Google Docs but my formula =INDEX(B2:F2,MATCH(10^99,B2:F2)) =INDEX(B2:F2,MATCH(10^99,B2:F2)-1) to find last and 2nd last number in range are both returning first? Any suggestions Thanks
  9. M

    Checking Duplicates in Google docs

    I am an encoder of ebay and we are using google docs to encode all sold items of ebay sellers.. I would like to ask if there is any format to check duplicate cell in google docs.. below is the format of the excel. <tbody> F G H I E1 Hello kitty plush doll pink E2 Transformer...
  10. E

    Stable, Functional Spreadsheet Sharing Platform

    I have large spreadsheet that I use to bid on construction projects that I need to have 10 to 12 users in simultaneously sharing the spreadsheet and entering numbers, running macros, sorting, filtering, adding rows, etc..... We tried this in Excel on our local area network and had lots of...

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