Excel Formula

  • Status: Open
  • Prize: $35
  • Entries Received: 11

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

  • gellieann3
    gellieann3
    • 14 hours 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.

    • 14 hours ago
  • ranashahed2000
    ranashahed2000
    • 15 hours ago

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

    • 15 hours ago
  • ranashahed2000
    ranashahed2000
    • 16 hours ago

    see the entry #17 . you will get your solution

    • 16 hours ago
  • IgeS
    IgeS
    • 1 day ago

    What version of Excel are you using?

    • 1 day 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!