I have attached the file. The file shows sales Qty in nos from 06-07 to 15-16.
I want to find CAGR %. I have applied one formula but not satisfied.
Can any body help?
Regards
PK
hi,
i have attached one file. In the file there are some mix used in product with corresponding weight given in the other columns of same row. I want to extract the mix which has maximum weight among all other mix shown in a particular row.
Pls help.
Hello sirs,
I am uploading a file that contains inventory data that run across thousand rows.
My twin objective is to optimize stk quantity to help production department work smoothly without bothering for shortages and at same time there should not be any excess stk lying idle in inventory...
Column C = Column (A+B)
Result of A + B in C have a few cells having 0 value.
Using find formula to highlight cells with 0 value is not working.
How to solve this?
Thanks
pradeep
Hello !!
Is there any formula in excel which covert numbers to words.
Exp - Rs 4563.54
Can this be converted to Four Thousand five hundred sixty three and fifty four paise.
regards,
pradeep
hi,
Data appears as below:
Col1 Col2 Col3.....
R1 1 2 3
R2 Apr May June....
R3 10 50 23
R4 15 25 33
R5 23 45 55
There 2 more tables with same structure but different data set. Each month for...
hello masters,
pls check the file in link below.
http://www.fileconvoy.com/dfl.php?id=g5051712ea57d5f62999270710c3598629db5671a3
check the graph in "mor" sheet. Now you change the date at cell no M8 in " data Sheet" to "28th jan 13". Now see the graph spreads till end of area.This is bcz...
Hello,
Can anyone help on this? Data may extend to 1000 cells
http://www.fileconvoy.com/dfl.php?id=g4a11ebfd720bbd2c999242718585202ff4493f8b6
best wishes
pradeep
Hello !
can anybody help to develop a graphical chart with check boxes. One check box represents date range ( from ... to) which need to be feed manually. Other check boxes represent different variables(each column in excel ).
Data for these variables are entered on daily basis.so whenever...