1. E

    Web Query limiting to 100 rows, nothing financial

    Hi! I just joined this forum out of desperation haha. I'm trying to link my Google Sheet to Excel Mac (latest version) and it limits the import to 100 rows, plus a message about "Finance Data Listing and Disclaimers." The Sheet I am trying to query has no formula related to anything financial...
  2. aqeelnokia99

    Google sheet help need

    hi all i am trying to get 5% of upcoming result auto in case of new value entered in Cell C i have try below formula but its not work =arrayformula(IF(C5:C="","",(D4*1.05)))
  3. R

    Google Trips Export to Excel

    Hello everyone, I've recently become aware of the data that Google stores about your past trips/travel (not on Google Maps but the flight/hotel info extracted from Mail). It's on the /travel of Google website. Each trip is shown as a widget and you can click in to see the dates and travel info...
  4. I

    Password a folder

    Morning. I have some zipped files that I need to keep for future reference. I wish to keep them in a folder on my pc & this is for my web site. I don’t wish to use google drive etc. Can the folder be password protected ?
  5. TAPS_MikeDion

    Google Sheets (Excel) - Always highlighted sheet?

    Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted? I'm guessing it's something simple I'm missing. Every time I go to that one sheet, even if I click a cell to remove...
  6. L

    Search, find, highlight cell - cells are hyperlinks

    Hi All I'm in need of some help - i'm trying to use conditional formatting to highlight individual cell when a word is typed. So if i start to type the word google - the cell containing the word google highlights red with a yellow font. So if i type g or goo the cell containing the word...
  7. B

    Need VBA to interact with PDFMaker addin

    Hi all, I have an Excel file with internal links that needs to be saved as PDF. I have found a way to manually do this using the PDFMaker add-in, but am now trying to automate this but am really struggling. I've tried to Google some results but have had no luck there either. Does anyone have...
  8. L

    Minimizing utility

    Hello guys, I have a file at work that has interesting functionality. It has a minimize set up for each month that you can expand to see per day. It's very convenient and i would like to replicate it, but I'm not sure what to even google for, maybe you have some ideas? Image of what i mean can...
  9. D

    Syncing w Google Calendar

    Is there a way to put a date/time in a cell in Excel and have that then synced to my Google Calendar?
  10. G

    Google sheets vlookup

    I have a vlookup in Google Sheets that isn't making sense to me. =MID(A3,search("(",A3,1)+1,6) returns 263972 =vlookup(263972,$S$3:$X$158,3,0) returns the expected result =vlookup(MID(A3,search("(",A3,1)+1,6),$S$3:$X$158,3,0) returns N/A. (Did not find value '263972' in VLOOKUP evaluation.)...
  11. S

    Google Datastudio alternative when using Excel

    Dear all I'm currently using Google Sheets to manage my stock portfolio. The system is to enter day which is tweaked and analyzed in many ways. To visualize data, current status and that I'm (hopefully) on track I use Google Datastudio. Actually I would like to move from Google Sheets to Excel...
  12. R

    Having a right nightmare with exporting Tab Delimited from 2003 to .txt format for Google Shopping Upload

    Hi I have been tearing my hair out with this conundrum and still no nearer to solving. We have a TXT feed from our website to Google Shopping which uploads every morning at 6:00am largely without errors. From time to time, we need to edit items and re-upload during the day. I have downloaded...
  13. E

    Split Column to text in google sheets custom

    I need to split the column into text please can someone tell me how to do this in google sheets <tbody> AJANTPHARM19JAN1180CE CE AJANTPHARM 19JAN 1180 ADANIPOWER19AUG65CE CE ADANIPOWER 19AUG 65 APOLLOHOSP19AUG1400CE CE APOLLOHOSP 19AUG 1400 </tbody> Above is an example of how the column...
  14. C

    Formula deduction

    I have created a spreadsheet in google sheets and I am having problems with the following formula. Please see attached link to the google sheet. In column K the formula works out the figure after a number is entered in column M but I need the figure in column K (after calculation) to also be...
  15. R

    IMPORTHTML Help (Google Sheets)

    Hi, I have previously used =IMPORTHTML to return the list data for all of the names under the headings: Goalkeepers, Defenders, Midfielders, Forwards - from the below webpage. However, this page has been redesigned and suddenly my formula N/As...
  16. S

    Show cell number or text by referencing several cells and select the highest of all(more than 3 items)

    Hi all, This is my first time asking question online for excel(mostly just google and have the answer) but i struggle to think of a good way to ask this question on google. Basically I am making a cell at E2(shown below) to show subject 1 OR A2 <tbody> A B C D E 1 subject 1 subject 2...
  17. M

    Google sheets - trying to convert formula to a script

    Good afternoon Demigods, I have the following formula in google sheets: What i am after is the formula converting to a google script. Any ideas please? Best regards manc
  18. A

    Remove Columns

    One of my worksheets stops at column "Z" and there's nothing to the right of it. How did I do this ? Can't remember and can't find how from Google. Thanks.
  19. H

    Textbox value to cell

    I need some Help to get Value from 16 differens Textbox to set value in Specific cell's on my Userform12 textbox 1 to cell P7 textbox 2 to cell P8 and so on to Textbox 16 i have search around google but not find the answer i want
  20. Q

    VBA - Search Google

    I have the following code which triggers when the user double clicks on a field: Application.FollowHyperLink "" & BusinessName This works fairly well and opens Google to search for the value in the BusinessName field. However, some Businesses contain "&" -...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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