I want to find the corresponding header and position for each person in the attached table. Basically I would like a formula in the green cells to pull the corresponding position number to the right of each name in column E and the bar name in row A. What is the best way to do… Read More If name exists in a table then return value from another column or row

In google sheets, i made a table with lists of film and also with link with reviews. Based on those reviews I wanted to scrap average percentage out of the website so I write a formula like in the picture.1 But problem is that result 59% this formula put also into the next cell like… Read More Google Sheets – results of formula in wrong cell

I would like to calculate the percent change of a quantity for each time it appears associated with a particular string. The example uses salaries and names. Each time a person salary is updated, it is added to the sheet. I want to automatically calculate the percent change from their previous salary listed. I am… Read More Google Sheets: calculating the percent change between entries in a column based on another column

I use the formula =ArrayFormula(left($A2:$C2,1)) to get the first digit of double digit numbers. if data is 12, the result is 1. if data is 2, the result is 2. as expected. I would like the formula to give 0 when it is a single digit number instead of 2 in the above example. so… Read More Right function with single digits in Google sheets

I’ve found similar questions, but none with this type of condition. I need to join all cells that are dependent of another cell, separating it by comma. So, If A2:A has repeated values, concatenate all the correspondennt B2:B, the dependent cells from the A2:A. Given the sheet: Column A Column B Jhon One Jhon Two… Read More How concatenate cells under a condition across columns using ARRAYFORMULA?

I’m using Google Sheets and want to import every cell in Col16 where Col 3 is not empty to another sheet. So far so good and this is the formula which does exactly that: =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/XYZ";"XYZ!A2:BZ"); "SELECT Col16 WHERE Col3 IS NOT NULL"; 0) The problem is that Col16 contains cells which start with a number… Read More Query Importrange doesn't import every cell

i have html code in cell C2 <b>Send my score to my teacher.</b> <br><br> <form class="login-form" action="send_results_processor.php?id=44623" method="post"> <table style="font-size: 14px;"> My full code in link: https://jsfiddle.net/bvotcode/z195augp/ My Google sheet (editable): https://docs.google.com/spreadsheets/d/1PX7VMX9QbC-RyIlp7EM3PpYCdbc_6EvYX6xPV18OXbw/edit?usp=sharing How can extract id number, eg:44623 in above code and put it in cell C3 Thank you >Solution : You may try: =REGEXEXTRACT(B3,"id=(\d+)")

As shown in the image below, I’m trying to sum values based on range criteria. Exemple Watch what I’m trying to do: =SUMIFS(C:C, B:B, A:A) Expected result: 14 (the result of A, B, C, and D) >Solution : Or =SUMPRODUCT(sumif(B:B,A:A,C:C))

The idea is pretty simple, have a cell log date and time like NOW() when a cell in the same row or a specific cell is changed, But i didn’t find a solution without using Apps Scripts. Example: Ideally I’d like to use one formula to cover the whole Column, This is the best I… Read More Update cell value to NOW() only when a specific cell is updated Without Apps Scripts

I have a table with n rows with data, the rows are required to be placed to the right. Which is the chunk size, as shown Make a copy of sheet here: https://docs.google.com/spreadsheets/d/1aitrEnBpL7VV_qiylF4d00tLcKq9efU99hdO-5fa1RM/copy The chink size is a variable and when chunk is changed the formula needs to auto adjust the result. I have tried… Read More Split the rows and orgzinze as multi columed row using Google Sheets formula