Excel Formula

  • Status: Pending
  • Prize: $35
  • Entries Received: 16

Contest Brief

e.g. I have 3 cells:

A1={"A","B","C"}

B1={"1","2","3"}

C1={"X","Y","Z"}

They are single-cell arrays no text, see: [login to view URL]

I need a formula to generate D1="A 1 X , B 2 Y , C 3 Z"

The single-cell arrays (A1,B1,C1) are the same length but no just 3, can be N.
No VB allowed.

SEE ATTACHMENTS,

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)

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • imfarrukh47
    imfarrukh47
    • 2 days ago

    did you checck #25

    • 2 days ago
  • douglimafanny
    douglimafanny
    • 4 days ago

    My excel is in Portuguese, but follows formulas ..., you need to insert a parameter line, Column D =UNIRTEXTO(" , ";VERDADEIRO;F2:O2), Column E (NÚM.CARACT(FÓRMULATEXTO(A2))-3)/4
    "Qty" Column F SE(F$1>$E2;"";EXT.TEXTO(FÓRMULATEXTO($A2);1+4*F$1;1)&" "&EXT.TEXTO(FÓRMULATEXTO($B2);1+4*F$1;1)&" "&EXT.TEXTO(FÓRMULATEXTO($C2);1+4*F$1;1)) As many fields as you need, the locks are already in place, just drag. With parameter at line one in field F1 = "1" G2 = "2": N

    • 4 days ago
    1. douglimafanny
      douglimafanny
      • 4 days ago

      Column F:ZZ =IF(F$3>$E4;"";MID(FORMULATEXT($A4);1+4*F$3;1)&" "&MID(FORMULATEXT($B4);1+4*F$3;1)&" "&MID(FORMULATEXT($C4);1+4*F$3;1))
      My example was with 10 combinations

      • 4 days ago
    2. RonaldAlexi
      RonaldAlexi
      • 3 days ago

      Genial!

      • 3 days ago
  • frlncr2
    frlncr2
    • 4 days ago

    May you please extend the date. I checked it only when about 5 minutes was left to paricipate in the contest!

    • 4 days ago
  • bartan29
    bartan29
    • 4 days ago

    Hi sir, I hope you want to check entry #26 and let me know what you think.

    • 4 days ago
  • imfarrukh47
    imfarrukh47
    • 4 days ago

    hi check #25 i uploaded my entry. can be extended as many columns as you want.
    no helper cell no vba

    • 4 days ago
  • gellieann3
    gellieann3
    • 5 days ago

    I don't think what you'd like is possible without limiting the number of records on each cell. I suggest to approach it differently.

    • 5 days ago
  • ranashahed2000
    ranashahed2000
    • 5 days ago

    eg2 same as eg. for both solve see entry #17

    • 5 days ago
  • ranashahed2000
    ranashahed2000
    • 5 days ago

    see the entry #17 . you will get your solution

    • 5 days ago
  • IgeS
    IgeS
    • 1 week ago

    What version of Excel are you using?

    • 1 week ago

Show more comments

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!