# If name exists in a table then return value from another column or row

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

# Google Sheets – results of formula in wrong cell

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

# Google Sheets: calculating the percent change between entries in a column based on another column

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

# Right function with single digits in Google sheets

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

# How concatenate cells under a condition across columns using ARRAYFORMULA?

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?

# extract id number in cell of Google sheet

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+)")

# Trying to use SUMIF matching two range of values

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))

# Update cell value to NOW() only when a specific cell is updated Without Apps Scripts

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

# Split the rows and orgzinze as multi columed row using Google Sheets formula

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