Results 1 to 2 of 2

Combine text from multiple cells based on criteria from other cells

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2017
    Location
    Plovdiv
    MS-Off Ver
    2016
    Posts
    1

    Combine text from multiple cells based on criteria from other cells

    I have a large Bill of Quantities (more than 3000 rows).
    The person who made it separated the description in column "C" into different rows which makes it impossible to sort by description which I need to do.
    The only criteria that I can use is column "E".
    For example I want to combine C4 to C6 into F6 and than delete rows 4 and 5 using weather E4 to E6 is empty or not.

    Please help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. combine cells based on criteria
    By jjbigfish77 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2016, 06:09 PM
  2. Combine cells based on criteria
    By thisismyname2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2016, 04:16 PM
  3. [SOLVED] Combine multiple cells text into one cell, skip blank cells.
    By T15K in forum Excel General
    Replies: 6
    Last Post: 12-05-2014, 09:49 PM
  4. Combine multiple text cells if value exists in other cells
    By epoch555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 03:50 PM
  5. Combine text from multiple cells, Based on conditions
    By dark_horizon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-19-2012, 11:07 AM
  6. [SOLVED] Using IF to fill cells with TEXT to show staus based on multiple criteria
    By karstens in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-26-2012, 10:23 AM
  7. Replies: 2
    Last Post: 12-03-2011, 03:51 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1