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

  • Status: Closed
  • Prize: $10
  • Entries Received: 2
  • Winner: zskl

Contest Brief

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.

Recommended Skills

Employer Feedback

“Thanks, simple fast solution”

Profile image michalemem, Czech Republic.

Top entries from this contest

View More Entries

Public Clarification Board

  • michalemem
    Contest Holder
    • 1 month ago

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

    • 1 month ago
  • michalemem
    Contest Holder
    • 1 month ago

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

    • 1 month ago

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!