I have a Google SpreadSheets doc with three columns A, B and C. I need to populate the Column C with all the possible combinations of the values in Columns A and B. Please take a look a the captur...

I've got a long spreadsheet with numbers. I need to get them in one string delimited by ; eg. 4364453;24332432;2342432 I know I can do: =concat(A1:A2000) but that will merge it in one string w...

I am trying to do a vlookup under a circumstance of first then last name to get an age. This will be done within Column A, then Column B. If found in Column A, Continue to Column B, If found in Col...

I have a need to search a row of cells, and for every cell that contains a specific value, return the value from the cell above. For example, consider the following +---+--------+--------+------...

I tried using TextJoin function with IF in it, but it somehow doesn't seem to work. I think I've written the formula correctly, but it doesn't give the solution I'm attempting to get. Objective: ...