I'd like to know if there is a formula or a way in google sheets that : 1/ for each value "sku" and "princing" I have a dedicated set of "rows" that replicate t
Having a bit of trouble using importJSON for the first time in Google Sheets. My data is importing as truncated and I can't find any way to really filter things
Im having trouble importing data from my another sheet. Its quite big, has over 500 rows and to 100 columns. (I dont know if thats important but it has about 50
I would like to get the "3,776" price in this website. https://jp.mercari.com/item/m68422230699 I copy the full xpath, but it returs #N/A =IMPORTXML("https://jp
I'm trying to get the sum of all items in column F:F when Column J:J = "Channel"and Column K:K = "Country" =DSUM(Sheet1!$A$1:$K$142,Sheet1!$F$2:$F$142,{{Sheet1
So I am having some issues with extracting the correct data to the "Battery Logs" Sheet from "FC" Sheet. I am trying to copy the data from the column range C2:D
I have created three google sheets wherein one google sheet is designed as the Masterfile for the data present on the two other google sheets. I was able to mer
I have used importhtml function for google sheets many times and successfully but sometimes I have had no luck in getting it to work. I am doi
How to check if a cell in google sheet contains $ (USD dollar) currency or Rs. (Pakistani Rupees) currency to calculate two different currencies total?
Does the IMPORTDATA function refresh the data automatically in GSheets?
I have a very simple Dropdown on Google Sheets that is working perfectly. Basically when I select an item from the dropdown, it will output that same item on an
The problem consists of concatenating multiple horizontal ranges containing product1, brand1, price1, product2, brand2, price2 and so on, even when the cells ar
I want to pre-process my data like the Result section of the attached image before flattening and using it. I want to write an array formula in the cells marked
I'm trying do create a master sheet for work, as for nom we work in the middle age, copying some data to up to 4 differents documents and I want that to change
In Google Sheets, is there a way to calculate the width, in pixels, of a piece of text given a font and a font size? Excel has a PixelWidth function, but I didn
I am using the IMPORTHTML function in a Google Sheet cell to import commodities performance table from website : https://www.investing.com/commodities/real-time
I am a newbie on importxml and trying to scrape the property agent information from a website, I did success to get the required field from the page, but:- Ther
I'm trying to get the values for column C in Table 1 from column H by using vlookup. However, seems like the vlookup doesn't work and return a N/A. I had check
I am getting this error on my query. Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC I don't understand whats the problem is
I have found code for a basic 2 column Cartesian join but I have a slightly different situation. There are 3 Variables/Columns: Color, Color ID, & Item. I'd