Recent content by musthu

Solved it with sum product

Please find attached test file, I have to distribute the value in sheet2 , as defined in sheet 1 Thanx

Try index fucntion , INDEX(array,row_num,column_num) returns the value of a specified cell or array of cells within array.

Wha.. this did the job man. Thanx.:)

Thanx for that . its working but what if the years are different ? i tried the dateif fucntion but not working properly.

I would like to distribute the value over the period mentioned, The distribution should be low at the starting and ending stage and would be peak in the middle stages. The % mentioned is an eg: its not determined.only thing it should be as per the above mentioned if the % is determined for...

Can anyone help me out with this. Just want to distribute the value in series order. plz check the file attached

Is there a way to copy the sum,count etc... results showing in the tool bar below when we select a range of cells. (hope this might have been asked before but couldnt find it)

thanks for information

is this ok

Have a biglist of cost in 1 column, the problem is some are in Euros and some are in Dollars, etc. IS there any simple way so that the total sum can be made into either in euros or dollars

Thanx for the corrections. it works perfectly now.

I tried with formula , but the result shown is zero. sample file attached. Is there a mistake in it? Thanks for your reply

Thanks i am pretty much bad with coding any way let me give a try.

308.28 16-Oct-06 220.42 19-Dec-06 192.35 16-Aug-07 251.06 20-Sep-07 445.76 10-Dec-07 0 17-Dec-07 25.56 17-Jan-08 170.35 3-Feb-08 149.24 3-Feb-08 The Colum A contains set of values and B has the corresponding year for that value. I'd like to have the average...