Results 1 to 13 of 13

Data Extraction from Comma Separated Values in Excel Cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2016 Professional Plus
    Posts
    130

    Data Extraction from Comma Separated Values in Excel Cell

    Hi Everyone!
    I have attached an excel workbook which contains two sheets named "before" and "after" respectively. The "before" sheet contains the sample data to work with and "after" sheet is the desired output for few entries in "before" sheet for the sake of example. Coming to my question, The "before" sheet contains some comma separated values. Each Comma separated value contains the shipping cost in dollar and the term either "available" or "not available". I want find out the lowest possible shipping cost out those comma separated values which contain the word "available" . Here we would ignore those comma separated values which contain the word "not available" and its of no use to use. I have attached the work book and you can easily understand by check it.

    Again many thanks in advance
    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. [SOLVED] Sum values using vlookup with lookup cell containing comma separated values
    By tmalito in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-08-2019, 10:14 AM
  2. Replies: 1
    Last Post: 07-09-2018, 02:38 AM
  3. Doing a look up on a cell with comma separated values
    By floragraga in forum Excel General
    Replies: 3
    Last Post: 05-10-2017, 04:35 PM
  4. [SOLVED] Using comma separated values in a single cell
    By joerobb in forum Excel General
    Replies: 7
    Last Post: 01-16-2015, 08:45 AM
  5. Function for Comma-Separated Values within Cell
    By SoothSailor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2014, 06:21 PM
  6. Replies: 3
    Last Post: 02-21-2013, 12:48 AM
  7. Resolved >>> Comma separated values in a cell
    By usr789 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2007, 08:36 AM

Tags for this Thread

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