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

  • Hali: Closed
  • Zawadi: $10
  • Wasilisho Zilizopokelewa: 2
  • Mshindi: zskl

Maelezo ya Shindano

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.

Ujuzi unaopendekezwa

Winner
Shindano Lililohusishwa
Tuma Shindano kama Hili

Maoni ya Muajiri

“Thanks, simple fast solution”

Picha ya Profaili michalemem, Czech Republic.

Wasilisho kuu kwenye hili shindano

Angalia wasilisho zaidi

Bodi ya Ufafanuzi ya Umma

  • michalemem
    Mwenye Shindano
    • Miaka 5 iliyopita

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

    • Miaka 5 iliyopita
  • michalemem
    Mwenye Shindano
    • Miaka 5 iliyopita

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

    • Miaka 5 iliyopita

Jinsi ya kuanza kwa kutumia mashindano

  • Chapisha Shindano Lako

    Chapisha Shindano Lako Haraka na rahisi

  • Pokea wasilisho nyingi

    Pokea Wasilisho Nyingi Kutoka kote ulimwenguni

  • Tuza wasilisho bora zaidi

    Tuza wasilisho bora zaidi Pakua faili - Rahisi!

Tuma Shindano Sasa ama Jiunge nasi Leo!