Matching Dates and Prices

[zarezzz]

I want to sort out the dates to the corresponding share price of a company i have four companies NWH, SST, CDD, IDL. CDD is the one that is most traded and has largest date range and prices. I am thinking its a combination of IF and MATCH function but I am uncertain in how to apply this. As you can see SST is not traded frequently. This is for 3 years worth of data so copy paste not an option for each date. Here is snippet of the excel sheet.


NWH SST CDD IDL
2-Jan-08 2.92 3-Jan-08 9.99 2-Jan-08 7.148882 2-Jan-08 2.1
3-Jan-08 2.87 17-Jan-08 9.85 3-Jan-08 7.139156 3-Jan-08 2.1
4-Jan-08 2.8 18-Jan-08 10.2 4-Jan-08 6.944628 4-Jan-08 2.1
7-Jan-08 2.69 31-Jan-08 10.15 7-Jan-08 6.662563 7-Jan-08 2.01
8-Jan-08 2.62 6-Feb-08 9.85 8-Jan-08 6.808459 8-Jan-08 1.965
9-Jan-08 2.55 22-Feb-08 10 9-Jan-08 6.827912 9-Jan-08 1.845
10-Jan-08 2.6 12-Mar-08 10.6 10-Jan-08 6.711195 10-Jan-08 1.77
11-Jan-08 2.59 4-Apr-08 11 11-Jan-08 6.584752 11-Jan-08 1.815
14-Jan-08 2.5 14-Apr-08 10.7 14-Jan-08 6.273509 14-Jan-08 1.725
15-Jan-08 2.5 22-Apr-08 11.15 15-Jan-08 6.030349 15-Jan-08 1.77
16-Jan-08 2.4 6-May-08 11 16-Jan-08 5.835822 16-Jan-08 1.695
17-Jan-08 2.45 9-May-08 11 17-Jan-08 6.147066 17-Jan-08 1.725
18-Jan-08 2.43 12-May-08 11 18-Jan-08 5.981718 18-Jan-08 1.71
21-Jan-08 2.38 13-May-08 11 21-Jan-08 6.137339 21-Jan-08 1.68
22-Jan-08 1.975 14-May-08 11.15 22-Jan-08 5.738558 22-Jan-08 1.44
23-Jan-08 2.05 16-May-08 11.3 23-Jan-08 5.835822 23-Jan-08 1.545
24-Jan-08 2.05 23-May-08 11.3 24-Jan-08 5.826096 24-Jan-08 1.62
25-Jan-08 2.31 2-Jun-08 12 25-Jan-08 5.89418 25-Jan-08 1.65
29-Jan-08 2.2 10-Jun-08 12 29-Jan-08 5.923359 29-Jan-08 1.89
30-Jan-08 2.24 18-Jun-08 11.7 30-Jan-08 5.719106 30-Jan-08 1.86
31-Jan-08 2.41 23-Jun-08 11.7 31-Jan-08 5.738558 31-Jan-08 1.815
1-Feb-08 2.35 24-Jun-08 11.7 1-Feb-08 5.835822 1-Feb-08 1.83
4-Feb-08 2.34 2-Jul-08 11.8 4-Feb-08 6.147066 4-Feb-08 1.83

Thanks so much

 

[venkat1926]

"I want to sort out the dates to the corresponding share price of a company"

not clear. what do you want. take the case of first two columns corresponding to the stock NWH.

why dont you just sort ccording to column B you will get

you will get

NWH price
22-Jan-08 1.975
23-Jan-08 2.05
24-Jan-08 2.05
29-Jan-08 2.2
30-Jan-08 2.24
25-Jan-08 2.31
4-Feb-08 2.34
1-Feb-08 2.35
21-Jan-08 2.38
16-Jan-08 2.4
31-Jan-08 2.41
18-Jan-08 2.43
17-Jan-08 2.45
14-Jan-08 2.5
15-Jan-08 2.5
9-Jan-08 2.55
11-Jan-08 2.59
10-Jan-08 2.6
8-Jan-08 2.62
7-Jan-08 2.69
4-Jan-08 2.8
3-Jan-08 2.87
2-Jan-08 2.92

price will be ascending and the corresponding dates.

like this you can sort for each stock.

if are thinking of something else give examples

 

[konew1]

how does your data show that SST is not traded often.