Search results

hi kutty, i am not sure about what you are looking for, but i think the following link file will help you. download the file, open it, right click on any cell and choose "insert date". https://www.dropbox.com/s/o61men4r4jf48ip/Calendar.xls regards sudipta

K.Govardhan how would you like to get your data if you filter multiple name of pan number? regards sudipta

salviakshay can you upload the sample file through dropbox? because your logical formula related to 'if' is not clear. regards sudipta

salviakshay i think your formula is not complete, you have missed the 'value_if_false' in 'if' formula. regards sudipta

dear Muhammad Shakeel except macro why don't you use a formula, go through the link below may be it help you... https://www.dropbox.com/s/e621b5vzywy4501/Macro%20for%20Vlook%20Up.xlsx regards sudipta

@webmax thanks a lot, but don't use the word kindly, after all we all are the friends @Debraj Roy thank you for your support thanks to both of you regards sudipta

hi hui, thanks again for your help, but need one more help on this topic, can't we get the "SR.NO" serialy except "x" on sheet2? https://www.dropbox.com/s/vzg8blh73qsvugw/COPY%20TEXT.xlsm regards sudipta

thank you hui regards sudipta

hi friends, need your help, what i want is in sheet1 only one row is there where user will fill, and end of the row a command button is there which is clicked by the user after complete the details at that row. when the user will press that button the entire data of the row will be copied to...

dear all, i just wants to know is there any way to insert multiple number of rows or columns in a worksheet? say in a report i wants to insert 115 number of rows after a302, or wants to insert 9 columns after column "J", how to do that at a time? one way to do that is after selecting 9 columns...

@nazmul_muneer are you from vodafone??????? regards

@SirJB7 sorry to say but i think a little mistake done by you... your formula is '=B$6*IF(MOD(COLUMN(B$6)-1,$B$1),1+$B$2,1)' where u have missed "=0" the formula must be "=B$6*IF(MOD(COLUMN(B$6)-1,$B$1)=0,1+$B$2,1)" may be i am wrong, if so then sorry.. regards sdey73

hi debraj, thanks for your reply and for suggested links. regards sdey73

@Debraj Roy realy you are genius, thank you very much, the given formula solve my problem, just one help more, wants to know the function of 'mod' or any link i can found it. regards sdey73

sorry, please go through the following link.. https://www.dropbox.com/s/kmiay7lxqvgd1to/rent%20change.xlsx regards sdey73

dear all, i am feeling so happy that a question from me create a competition, you all are genius, relating above matter now i want some more help from you. this time the number of year and the growth percentage to be mentioned in a cell. say the rent for the first year is 50000, i have put the...

@oldchippy thanks, its works. regards sdey73

@vijay, thanks for your soon reply, but i need the format like below... 1st year 2nd year 3rd year 4th year 5th year 6th year 7th year 8th year9 th year 10th year 50000 50000 50000 57500 57500 57500 66125 66125 66125 76043.75 regards sdey73

dear, i need your help to solve this, 1st year the rent is 50000, it will be same for next two years, on the 4th year it will increase by 15%, and going on. i mean the rent will increase 15% each after three years. please any suggested formula...... regards sdey73

why r u asking the same question again? http://chandoo.org/forums/topic/how-i-can-apply-any-formula-in-a-cell-where-already-something-written

i have more than one pivot tables and wants to combined in one. how is it possible? please help. sda