- Status: Pending
- Hadiah: $35
- Penyertaan diterima: 15
- Pemenang: ranashahed2000
e.g. I have 3 cells:
They are single-cell arrays no text, see: [login to view URL]
I need a formula to generate D1=&quot;A 1 X , B 2 Y , C 3 Z&quot;
The single-cell arrays (A1,B1,C1) are the same length but no just 3, can be N.
No VB allowed.
IN [login to view URL] A1, B1,C1 CELLS ARE ENTRIES, D1 IS WHERE YOUR FORMULA SHOULD BE,
In other words the data is in A1, B1, and C1, you need to do a formula which match with D1, and should works for bigger Arrays
Many answers works just for 3 element arrays, thats why now , In [login to view URL] you can test your formula in D4, (same formula should return D1 and D4 content)