google

I want to combine two formulas in an IF statement? I have this formula: IF (Data!CX43="False"), then proceed with this array formula: {=IFERROR(INDEX(Table!$C$2:$C$1000,MATCH(1,(Data!CT45=Table!$B$2:$B$1000)*(Data!CN45=Table!$A$2:$A$1000),0)),0)} otherwise return "0". I've googled the "google'...

Hi Friends, I am new to VBA, Need help to work this code in Google Chrome instead of IE since its not supported by Web Site: Private Sub uploaddata_Click() Dim ieDoc As Object Dim sws As SHDocVw.ShellWindows Dim strURL As String Dim n As Integer 'Set main URL to evaluate open IE windows...

Dear all, Kindly advise, why is it happening that the first two charts here have lost last few "X-asis" labels? In comparison with the other charts, where all the labels are present, and the same formulas and data ranges are used for X-axis...? Also, is there any way to switch the vertical...

I have a nephew that plays different country music gigs. He wasn't aware that he could claim the mileage on his truck to the IRS. There's no chance that I can get him to remember to write down his starting and ending mileage for each gig, but he posts all of his locations. What I need is a...

I'm trying to click the "Google Search" button on google's homepage. The source code from google.com: <input value="Google Search" aria-label="Google Search" name="btnK" type="submit" jsaction="sf.chk"> In my VBA, I have: Dim v As Object [Insert A1's value such as...

I use the googlefinance function in google sheets to import financial data from into an excel sheet. Since last night london share tickers were returning #N/A. I've change my tickers from the form "ABC.L" where the L is for london to "LON:ABC" and all has come good. Hope that helps someone else!

Good day guys. I'm looking for a way to list all used number formats in my workbook, along with a count of how many cells use each number format. I've tried running a loop through each cell in each worksheet, but I can't get it to work. Google has not provided any usable results :eeek: Does...

Hi Sorry if that is off topic. I want to know the difference between these 3. I google it but no one seems can explain it in easy and understanding way. Thank you.

hi every one, i have this in google sheet named "123", sheet1 (please dont delete this thread if google sheet is not supported here): i have this in google sheet named "456", sheet2 (2 separate google sheets files): and i want this: - if A2&B2 in "456", sheet2 matches any value in A&B in...

Hello- Not sure this is the right spot for this one... I have issues with coworkers uploading an Excel file that I have password-protected into Google Sheets, which removes all of the protections I have created (sigh), and allows them to see hidden sheets, etc. I am wondering if there is some...

My Google Chrome crashed on Wednesday. I can' start Chrome, I get the aw-snap not enough memory message. I can't access office 365 - I tried to reinstall it and I get an error message about a storage dll missing. Yet, I get the message that everything is installed and ready to go. Or, if I try...

I want to create a macro that follows a hyperlink that references a cell in the active workbook such as the example below. Say cell A1 says "baskeball", this would search for basketball in google. Private Sub Label1_Click() ActiveWorkbook.FollowHyperlink...

I would like to use a Excel sheet to manage the links on several google sites, such that I create links on my sites to the contents of a cell in an Excel spreadsheet, which contains a link to another document. This would enable editors of the spreadsheet to change the results of the links in the...

If B$2 is greater than or equals to today() and if $a2 is greater than 0 insert "Yes" other wise "No" I've a Google Sheet where you can spread your magic dust. Have you look here https://docs.google.com/spreadsheets/d/1ofGGVs0UBpWHMKhzlGdwIaOEm3VFd9qumZ9AWUmzLcw/edit#gid=0

Hi I have one computer. I want to learn how to Share/Track changes in excel. I want to see how 2 or more users can share a workbook and make changes and then track changes. Any idea how to simulate that? I am thinking to save a file in Google drive but how can I create 2 different dummy users...

A (Stock) Facebook Amazon Netflix Google Facebook Google B (Action) Buy Sell Sell Buy Sell Sell C (Quantity) 100 50 75 100 100 50 D (Price) 150 1000 150 1000 175 800 What's a formula if I wanted to see how much I spent on buying just google? (Google + Buy -> Quantity * Price) Thank you!

Hello What is the max value I can enter in a cell. I tried =100^200 and I got #NUM message. I tried to google it but once I enter Maximum all results come related to Max() function! Thank you.

Hi I've been pulling my hair out for hours trying to figure this out with no luck. I am collating data this is pulled in via a Google Survey to a Google Sheet. When the survey gets a submission it adds a new row so I have used the INDIRECT and COUNTIF formula on a separate sheet to count the...

Hi, I am familiar with accessing the elements of a webpage using the CreateObject("InternetExplorer.Application"). I was wondering if there is a similar way to access the elements of Google Chrome and Firefox Mozilla ? Thanks.