Google Sheets formula - multiply all combination of all cells into Column6

  • Status: Closed
  • Præmier: $10
  • Modtagne indlæg: 2
  • Vinder: zskl

Konkurrence Instruktioner

I need to get results in Column6 from multiplication of cells Column2 and Column4

Input data:
Column1 | Column2 | Column3 | Column4
car | 1 | used | 1
vehicle | 2 | old | 4
auto | 2 | bazar | 2

Column5 - I already know the formula, its "=ArrayFormula(transpose(split(rept(concatenate(A3:A5000&char(9)),counta(C3:C5000)),char(9)))&" "&transpose(split(concatenate(rept(C3:C5000&char(9),counta(A3:A5000))),char(9))) )"

Column6 - for each combination i need multiplication Column2*Column4 (eg. 2*4=8)

Result data:
Column5 | Column6
car used | 1
vehicle used | 2
auto used | 2
car old | 4
vehicle old | 8
auto old | 8
car bazar | 2
vehicle bazar | 4
auto bazar | 4


Take in account Column1 and Column3 could expand into unlumited cells. So the input is not always 3x3 cells.

I would like to remind, that result should be in Google Sheet, not in Microsoft Excel. Unfornunataly, this is condition.

Anbefalede Evner

Arbejdsgiverfeedback

“Thanks, simple fast solution”

Profilbillede michalemem, Czech Republic.

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • michalemem
    Konkurrenceafholder
    • 1 måned siden

    Also, take in account Column1 and Column3 could expand into unlumited cells. So the input is not always 3x3 cells.

    • 1 måned siden
  • michalemem
    Konkurrenceafholder
    • 1 måned siden

    I would like to remind, that result should be in Google Sheet, not in Microsoft Excel. Unfornunataly, this is condition.

    • 1 måned siden

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!