google

Hi..Im a beginner in VBA and wanted to know the code to get the results of a google chrome search page ie specifically the URL's of different websites listed in the google search page from inspect.

Hi all. Column A has my search query and I want to be able to get column B to display the domain name for the first search result only. I prefer google but any search engine should do. What are some ideas on how to go about doing this? For example: <tbody> Pizza pizzahut.com Los Angeles...

Hello, I am working on a to-do list in google sheets and my boss wants some of the information to be private. If the row has HR in column E she wants it to be hidden for everyone except her. I also need everyone to be able to edit the document. Does anyone know how to accomplish this or...

Hi Guys, I need to transfer this google sheets formula to excel formula is possible please. https://docs.google.com/spreadsheets...xU8/edit#gid=0 =ArrayFormula(IFERROR(VLOOKUP(ArrayFormula(P30&N32:N),{ArrayFormula(T31:T130&U31:U130),V31:X130},{2,3,4},False))) Would anyone be able to advise

Hi Guys, I'm working on a data cleanse project at the minute where I'm trying to fill in as many gaps in our data as possible (around 30k records running at 53% blank fields - Dealing with about 6 years of data migrations and lazy employees not focused on data quality) One of our fields is...

Hi I am looking for a list of characters that is used in Excel what for what reason. For example, I know "$" is used to lock a cell, "!" is used to refer to different tab, etc. Tried to google but got different things. Thank you very much

HI, ive made a one sheet document that i want to publish on google docs and use as a basic calculator when im on the move. trouble is when i open it in google docs all the spinner buttons do not appear..

I have an Excel spreadsheet with several tabs and a couple of Pivot charts. When I upload to my Google drive and convert to sheets, the pivot tables becomes just data, no longer a pivot table. Any ideas why?

In VBA, how can I go about converting the string "09Jan19" to a date value? I wasn't able to find anything with a Google search that addressed anything similar.

I am trying to get a spreadsheet working for a game I play which is useful information. The spreadsheet is hosted here and I saved a copy to my own Google Sheets. I wanted to make some changes and add some things but I'm running into issues. There appears to be differences with Google Sheets and...

Hello everyone, I need to extract the FirstName from cells in a particular format LastName,FirstName MiddleName1 MiddleName2 Note that LastName,FirstName has no space in between, only the comma so I adapted a formula I found on google to: =MID(A10,SEARCH(",",A10,1)+1,SEARCH(" ",A10,SEARCH("...

I'm wondering if having a more current version of Excel uploaded onto Google Drive will affect the functionality of what can be done? For example, if I have a file created in Excel 2016 and upload it to Google Drive, will I have more Excel features/functions than if the document was created in...

Hey guys. I have a workbook that our users register client details, and create quotations with. We are working to a more productive way of our users working, by offering them a 'fewer clicks' solution to their daily needs of the workbook, and I would like to be able to have the users click a...

Hi there, I have an Excel formula that I would like to calculate in Google Sheets instead of Excel (for data architecture purposes), but unfortunately it does not work on Google Sheets as-is :confused: I have made some research / tried some alternative formulas but I haven't been able to find...

Hello all, I am not a programmer and I am really struggling getting my Excel workbook to do something that has been very simple in google sheets with query formulas. I am currently gathering data daily with a Google Form into a Google Sheet for daily vehicle checks. I am wanting to be able to...

Hello, Has anyone found a workable solution to extracting information for Google Analytics into Excel.

Hi all I know we can paste values in excel, but is there any way to copy values? I.e have some numbers formatted as 0.0k so 1200 would show as 1.2k, i want to copy the value of that cell (1200) into a google sheet, but what goes into google sheet is 1.2k as a text string. In the above...

Hi All, I have the following formula that i used in google sheets but now putting my data on excel but need the following formula to work in excel or something that does the same Could anyone help at all please? <style type="text/css"><!--td {border: 1px solid #ccc;}br...

I have a column called number of days. In Excel I can pivot on that data for min and max value and I get the desired results. If I try to do the same this in Google Sheets, I get values of 0. Any ideas?

Hello World! I'm not sure if this is the right section to post this, but I'm needing some help. As of the beginning of July my company opted to ditch Microsoft Office (To cut expenses) and moved to Google. And that ruined a lot of my macros. I have no idea of how to script in google but I've...