Results 1 to 4 of 4

Thread: Gather a group of cells in a single cell based on a condition

  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0

    Gather a group of cells in a single cell based on a condition

    Explanation inside the Sheet
    Attached Files Attached Files
    Last edited by Admin; 01-29-2014 at 09:23 PM.

  2. #2
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    12
    a little macro?:
    Code:
    Sub blah()
    lr = Cells(Rows.Count, "B").End(xlUp).Row
    For rw = lr To 3 Step -1
      If Len(Cells(rw, 1).Value) = 0 Then
        Cells(rw - 1, 2).Value = Cells(rw - 1, 2).Value & vbLf & Cells(rw, 2).Value
        Rows(rw).Delete
      End If
    Next rw
    End Sub
    works on the active sheet and deletes rows so test on a copy first.

  3. #3
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    Thank you very much for your effort
    But I want it by the formula

  4. #4
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    12
    There is no straightforward formula that I can think of to do this. (While I'm there, there is no complex formula that I can think of to do this either.)
    It may be possible with a user defined function, but that would involve VBA too.

Similar Threads

  1. Replies: 1
    Last Post: 08-23-2013, 05:19 AM
  2. Replies: 5
    Last Post: 08-14-2013, 10:01 AM
  3. Replies: 4
    Last Post: 07-04-2013, 01:56 PM
  4. Replies: 2
    Last Post: 01-24-2013, 09:03 PM
  5. Calculation with different condition in a cell
    By LalitPandey87 in forum Excel Help
    Replies: 5
    Last Post: 04-04-2012, 08:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •