3 responses
Hi Mukil,
Let's say the data 20,30,69,80 is in range B2:E2 then put the following formula in F2:
=TREND(B2:E2,{1,2,3,4},5)
Best regards,
Trowa
Let's say the data 20,30,69,80 is in range B2:E2 then put the following formula in F2:
=TREND(B2:E2,{1,2,3,4},5)
Best regards,
Trowa
Hi Mukil,
I have put the numbers in range A1:D3:
In column F I have put the trend formula:
This results in:
In column G I have put an array formula (Array formula's need to be confirmed by hitting Ctrl+Shift+Enter):
This results in:
In column E i have put the following formula:
This results in:
Take a look at the formula in column E. It has the condition G1=4. The number 4 stands for the amount of numbers, which in this case is 4 (A1:D1), but I imagine that that number is different in your file.
Try to figure out what is happening and don't hesitate to reply if something is unclear or you need some more explanation/information.
Best regards,
Trowa
I have put the numbers in range A1:D3:
10 20 25 30 30 20 15 10 10 8 25 15
In column F I have put the trend formula:
=TREND(A1:D1,{1,2,3,4},5)
=TREND(A2:D2,{1,2,3,4},5)
=TREND(A3:D3,{1,2,3,4},5)
This results in:
37,5 2,5 22,5
In column G I have put an array formula (Array formula's need to be confirmed by hitting Ctrl+Shift+Enter):
=SUM(IF(A1:D1<F1,1,0)) =SUM(IF(A2:D2<F2,1,0)) =SUM(IF(A3:D3<F3,1,0))
This results in:
4 0 3
In column E i have put the following formula:
=IF(G1=4,"Increasing",ALS(G1=0,"Decreasing","Fluctuating")) =IF(G2=4,"Increasing",ALS(G2=0,"Decreasing","Fluctuating")) =IF(G3=4,"Increasing",ALS(G3=0,"Decreasing","Fluctuating"))
This results in:
Increasing Decreasing Fluctuating
Take a look at the formula in column E. It has the condition G1=4. The number 4 stands for the amount of numbers, which in this case is 4 (A1:D1), but I imagine that that number is different in your file.
Try to figure out what is happening and don't hesitate to reply if something is unclear or you need some more explanation/information.
Best regards,
Trowa
Hi Mukil,
I can't acces my e-mail from this workplace.
Can you upload your file using this link (without any personal information):
https://authentification.site
Best regards,
Trowa
I can't acces my e-mail from this workplace.
Can you upload your file using this link (without any personal information):
https://authentification.site
Best regards,
Trowa
hi trowa,Thanks for ur reply
Find out my excel sheet
https://authentification.site/files/20152816/Trend.xls
from
mukil
Find out my excel sheet
https://authentification.site/files/20152816/Trend.xls
from
mukil
Hi Mukil,
Why don't you fill the empty cells with 0's?, since if nothing is sold, the purchase rate is zero.
If you only sold something in the fourth month with a purchase rate of 8. Then the trend isn't 8 and constant, but a lot less and fluctuating.
If I understand your elaboration correctly this solves your query.
Otherwise let me know.
Best regards,
Trowa
Why don't you fill the empty cells with 0's?, since if nothing is sold, the purchase rate is zero.
If you only sold something in the fourth month with a purchase rate of 8. Then the trend isn't 8 and constant, but a lot less and fluctuating.
If I understand your elaboration correctly this solves your query.
Otherwise let me know.
Best regards,
Trowa
Dec 18, 2009 at 12:10 AM
Thanks . just i need its an increasing trend or decreasing trend or some fluctuations..
Ex:
if values are 10 20 25 30 then it should say increasing
30 20 15 10 then it should say decreasing
10 8 25 15 then it should say some fluct