ashesh32
Nepal
Google Sheets formula - multiply all combination of all cells into Column6
- 状态: Closed
- 奖金: $10
- 参赛作品已收到: 2
- 获胜者: zskl
Winner
竞赛简介
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.
您还可能感兴趣的技能
Winner
雇主反馈
“Thanks, simple fast solution”
michalemem, Czech Republic.
此竞赛的顶尖作品
公共说明面板
-
竞赛主办者 - 5 年 之前
Also, take in account Column1 and Column3 could expand into unlumited cells. So the input is not always 3x3 cells.
- 5 年 之前
-
竞赛主办者 - 5 年 之前
I would like to remind, that result should be in Google Sheet, not in Microsoft Excel. Unfornunataly, this is condition.
- 5 年 之前
