Relative Content

Tag Archive for google-sheets-formula

Simplify a google sheets formula so i don’t have to do it column by column

=ARRAYFORMULA( IF( ISNUMBER(SEARCH(“LST”, A2:A7)), FILTER(REGEXEXTRACT(A2:A7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, A2:A7))) & ” ” & A$1, IF( ISNUMBER(SEARCH(“LST”, B2:B7)), FILTER(REGEXEXTRACT(B2:B7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, B2:B7))) & ” ” & B$1, IF( ISNUMBER(SEARCH(“LST”, C2:C7)), FILTER(REGEXEXTRACT(C2:C7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, C2:C7))) & ” ” & C$1, “” )))) I have this formula and need to make it so I don’t have to do it […]

Google Sheet – If formula

I need help writing a formula that cell’s B7 & C7 will return specific text if cell J7 has specific text. (See below)

Count values in exact row

I want to count number of times a specific value shoes up in an exact row. For example, the table in the picture, if I write 501 under ID and add value 3, it should count all threes in second row (id 501)…enter image description here

Count values in exact row

I want to count number of times a specific value shoes up in an exact row. For example, the table in the picture, if I write 501 under ID and add value 3, it should count all threes in second row (id 501)…enter image description here