Search results

thanks

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

Thank u very much regards, 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

Thanks faseeh. Good solution. What i found , every time condition is change i have to change the cell no (like B12)in formula to get the result.can this not be automatic? 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...

solved. thanks pradeep

Hello, hui sir- Product A is sold 3 times in different quantities with different mixes & same may be the case with other products also. Secondly to answer pattnaik sir --requirement is to display only that mix of which product is made of (not the entire mix need to displayed) & it's...

Hello, can anyone solve this? http://www.fileconvoy.com/dfl.php?id=g1c94a3bbecda003d999243452df4534f8b8aa4fc6 cheers pradeep

Hi Marc, Want to keep only alphabets & numbers. thanks pradeep

Hello, Pls check it. http://www.fileconvoy.com/dfl.php?id=ga1569b55f9e55ac599924281560c53d0938f63b2c cheers pradeep

Hi, But special characters are not restricted to "-" ,"$" only. It may be anything. What will happen in that case?Can i use the same formula to get the results? best wishes pradeep

Hello, Can anyone help on this? Data may extend to 1000 cells http://www.fileconvoy.com/dfl.php?id=g4a11ebfd720bbd2c999242718585202ff4493f8b6 best wishes pradeep

Thank you. Wonderfully explained. I 'll catch u up on skype in the evening. regards, pradeep

Hello faseeh can u pls explain following: 1)how to draw two straight line on a chart , one showing maximum limit & other one for minimum limit. 2) the formula u used in "A" to "I" column of helper sheet. I dont understand logic. pls add me on skype. regards, pradeep

yes faseeh, it is done . I want to speak to you. Pls check ur mail regads, pradeep

Dear Faseeh Can u pls sort out above problem? This is quite urgent boss. Pls tellme the procedure also. rgds, pradeep

can u pls reply regards, pradeep

Hello Faseeh, In the last file you uploaded only one date is being displayed on chart even if data are available on different dates. Other dates need to be displayed on chart Pls observe file once again. Each quality has different batch no on column"B".May be one quality has different...

Thanks a lot sir. Pls explain the process when you are free. pradeep

Hello Sir! This is really fabulous!!!. "Quality Name" as shown in "A" column is to be shown in the chart as you did for "W" column. Batch no of particular quality is also to be displayed can one upper working limit & lower working limit be shown in the chart? Pls share me the entire...

Dear Faseeh, Here is the link: http://www.fileconvoy.com/dfl.php?id=gd98a73429ac51d08999226169ba2d08bd6dfcb579 Request you to resolve it soon pls. it is very urgent

how to upload? i dont find any upload button.

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...