+ Reply to Thread
Results 1 to 8 of 8

Using comma separated values in a single cell

Hybrid View

joerobb Using comma separated values... 01-15-2015, 11:02 AM
FDibbins Re: Using comma separated... 01-15-2015, 11:20 AM
newdoverman Re: Using comma separated... 01-15-2015, 11:53 AM
joerobb Re: Using comma separated... 01-15-2015, 02:07 PM
newdoverman Re: Using comma separated... 01-15-2015, 02:39 PM
joerobb Re: Using comma separated... 01-15-2015, 02:55 PM
newdoverman Re: Using comma separated... 01-15-2015, 04:32 PM
Santhosh AMASL Re: Using comma separated... 01-16-2015, 08:45 AM
  1. #1
    Registered User
    Join Date
    01-14-2015
    Location
    Anywhere, USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Using comma separated values in a single cell

    Wasn't exactly sure how to post a table, but here is an attempt at a table:

    B C D E F G H I J
    Date Trans Type Symbol Shares Price Total TransID Blocks Sold Profit & Loss
    1/5/15 buy goog 100 500 50000 3
    1/6/15 buy goog 100 500 50000 4
    1/10/15 dividend goog 5 505 2525 5
    1/14/15 sell goog 205 520 106600 6 3,4,5

    Basically, I need to know how to read in the values of 3,4,5 in I6 to calculate my P&L. This is similar to for loops (for iin $variable, do) Bash Scripting (not sure if there are any Linux user on this forum).
    Last edited by joerobb; 01-15-2015 at 02:14 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match a Value from a single-cell, comma separated list
    By secondchild12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-24-2014, 06:16 PM
  2. [SOLVED] Facing problem in a Macro which compares 2 columns having comma separated / single values
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2014, 11:18 PM
  3. Replies: 3
    Last Post: 12-23-2013, 12:32 PM
  4. [SOLVED] Single cell Comma Separated Values to validation list [DIFFICULT QUESTION]
    By jgema in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-31-2013, 08:48 PM
  5. Column/cells to single cell comma separated data?
    By egeorge4 in forum Excel General
    Replies: 1
    Last Post: 04-27-2007, 03:53 PM

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