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

[canis01]

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.

[Glenn Kennedy]

Hi, this should do what you want:

Please Login or Register  to view this content.

[Vikas_Gautam]

hey bro ..
use Advanced filter .... show unique records only...
to get the unique items... and their corresponding values...


Say thanks, Click *

[micope21]

Hi

F6

Please Login or Register  to view this content.

This is array formula! Press same time Ctrl+Shift+Enter, NOT ENTER! Then copy down.
This work from small to large!!

Regard
micope21

[excelliot]

hi

check this..

Cheers!!

[Glenn Kennedy]

Nice solution from micope 21. It's quite happy if there are blank rows in the Table.

[Vikas_Gautam]

Hi, this should do what you want:

Please Login or Register  to view this content.

Sorry a bit of correction to your forumla...
there is no need of second index forumla...
the corrected formula is...

Please Login or Register  to view this content.

[canis01]

thank you all guys, gonna apply and see your solutions, it's gonna take me awhile

//edit
Ok, I think I'll use micope21's solution, as it goes well with blanks, and in this case I need to make my records gradually, although the other solutions were also capable of solving my problem. Thanks to all once more