Google Sheets Formula - Growth, Regex Extract & Concatenate
Google Sheet is one of the widely used application tools of Google for data management. Formulae help a user to reduce the time consumption and allows to utilize the time for better productivity.
With the advent of technology, there has been enormous growth in various business segments for the past two decades and the growth will continue in the near future, so will their data too. And in order to make the business successful, the statistics have to be right and precise enough to chalk out the future plans.
Next, the question is how to make meaningful data available in order to support future needs? The sheets formulae can help the business to get the desired output from business data by using the right formula at the right time.
Formulae that I am going to describe in the article -
Growth: The GROWTH function will help you fit an ideal exponential growth trend, and give you data to perform analysis about growth trend.
Here’s the formula: =GROWTH(known_data_y, [known_data_x], [new_data_x], [b])
known_data_y is the array containing the Y values that are already known. These values are used to fit in an ideal exponential growth curve.
known_data_x are the values of the independent variables that correspond with known_data_y.
new_data_x are the data points to return the values for the ideal curve fit.
Finally, b is set to be TRUE or FALSE.
Regexextract: Regexextract is the formula to be used for extracting specific terms from a set of data. If you are having many words to look up from a huge set of data, you definitely cannot apply a filter in every column. At that time this formula comes to the rescue.
Here’s the formula: REGEXEXTRACT(text, regular_expression)
In this formula, the ‘text’ is the input text and ‘regular_expression’ is the first part of the text that matched this expression (the value which will be returned).
Concatenate: This function will combine the contents 1 or 2 more cells, into a third separate cell.
Here’s the formula: =CONCATENATE (string1, string2, string3, …)
You can also use a variation of the same formula to combine the data in cells AND incorporate a spacing in between the different data.
To do this, add a “ “ in between your strings.
Here’s an example, an initial =CONCATENATE (B3, C3) formula would now look like
=CONCATENATE (B3,“ ”, C3)