Recent content by dsb1985

Dear, thanks for your prompt responses. due to heavy file size unable to upload the data file, can you copy the same data upto 40000 to 50000 lineitem and copy the same formula down, you can see the process time & hangness issue in your sheet.

the stock data have more than 75000 lineitems, may be this is the reason for slow response of spreadsheet.

perfectly works, but it hangs the excel, don't know the reason or may be due to complex formula equation.

this formula calculate 3dma from 1st line item, but the 3dma should be start from 3rd line item, means first two rows should be blank

thanks to both bosco & excel wizard, will tested it

Sir, i think there is some error in formula, please see the below screen.. also find the attach sheet...

sorry for the unncessary data, but i want to apply moving average on closing price not on volume, so should i replace the volume column with closing price in your formula.

could not get the above formula, please see the below table. SC_CODE SC_NAME CLOSE PRICE DATE 3DMA 7DMA 500002 ABB 1313.05 08/01/2021 500003 AEGIS 258.25 08/01/2021 500008 AMARA 1002.1 08/01/2021 500009 A.SARA 23.8 08/01/2021 500010 HDFC 2653.4 08/01/2021...

Dear Members, i want to apply a formula on attach sheet to get 3DMA(7 day moving average) & 7DMA(7 day moving average). problem is highlighed cells(A2:A6) repeat because the stock data is for the period 08Jan to 21Jan. Regards, Deepak

Problem = I have a Fix AR Date in one cell and also have due date of invoices, in Due date column some cells have #n/a error. By use of IF(ISERROR) function i want if cells have any error then it returns Due, if AR Date is less than equal to due date (< or =)then it returns Due otherwise Not...