Results 1 to 8 of 8

moving cell values appearing multiple times into a table listing them only once

Threaded View

  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    25

    moving cell values appearing multiple times into a table listing them only once

    Hello,

    I have a table listing certain values (Column C) and their respective probabilities, based on normal distribution (Column D). As these probabilities are dependant only on values from Column C, I'd like to list all the values from that column into another fragment of the sheet, say F6 and below, but each value should appear there only once, no matter how often it occurs in its original Column C (I listed them manually in Column F in the enclosed example). Moreover, if a new value appears in Column C, it should be also included in the new place and sorted in increasing order.
    Many thanks for your help.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 01-30-2014, 04:42 PM
  2. Filter A Pivot Table Multiple Times Based On Values In List In Another Sheet
    By w.m.christensen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2013, 03:55 AM
  3. Replies: 3
    Last Post: 08-02-2011, 07:35 AM
  4. List of names appearing multiple times but with different adjacent value
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2011, 01:27 AM
  5. Recreating a column but listing each item multiple times
    By katie1343 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-07-2007, 05:34 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