Search results

Dear Friends, Could you suggest, How can I calculate what is the summation of all +ve numbers & all -ve numbers in the specific column. E.G. A1=20 A2=30 A3=-10 A4=-35 A5=54 A6=60 A7=-34 A8=85 C1=249 (Summation of all grater than zero numbers in column A) D1=-79 (Summation of all...

Dear Luke M Sir, Good morning to you!!! Since your blog, I were been re-tried to get it done with the help Hex editor but while find your suggested string the msg occurs as "A pattern was not found" I would like to admit here, I'm very basic in learner of VBA, I really don't know that...

Good day to you bobhc I have tried as per Ninja "Luke M" suggested in the blog "How to break VBA password" but fail to get it done :-(

Hi Friends, I have forgot VBA Project Password, i have tried "Hex Editor Neo" in this replaced DPB sring to DPx but getting error "A Pattern was not found" Can somebody please help me in this Thanks

Hi Faseeh, thanks, its working Sorry to update very late, as i were been stucked in hospital issues... Thnks,

Dear Narayan & YD, Thanks for feedback, but friends still it is not get solve

Dear Friends, I have, C4= 1 C5= 1.1 (=C4+0.1) C6= 1.2 (=C5+0.1) C13= 1.9 (=C12+0.1) C14=2 (=C13+0.1) C15=2.1 (=C14+0.1) but i need cell c14 should be 1.10 instead of 2 & cell c15 should be 1.11 instead of 2.1 Please suggest formula

Okie, Thanks SirJB7 Have a great weekend ahead :-)

Dear Chandoo Sir, Just wanted to know, if we have "Chandoo.org" in as android application. Thanks

Friends, meantime I have tried mercatog's codes & its working. Thanks

Dear mercatog, SirJB7 & Debraj Roy, Thanks & very good morning to all of you :-) May i go ahead with mercatog's recent codes to select data in the data origin sheet only means i data should visible as per selected criteria in data sheet only. Thanks. Happy learning... :-)

thanks it works, In another view of possible requirement, instead of get data in sheet1 can we select data in the data origin sheet i.e. "Data" Data should appear as per userform criteria in the origin sheet only, like other columns and rows should get hide...

Yup, have tried but fail to get it. doesnt matter about ur english...

Thanks Deb, Let me go through it. @ mercatog: could you pls make it little beat clear to understand more

Hi friends, I have a data sheet where i want "Select Data" button to select data by user form criteria EG: If im selecting following details with user form Brand: HCL Handset Type: IdeaPad Tablet K1 Handset Color: Black in data sheet data should show as per above selected criteria...

Dear Narayan, Just adding "Star of Bethlehem" in a bunch of roses...Congratulations!!! Thanks, Ajinkya :-)

Dear SirJB7, That why you are "Excel Ninja" Thanks it done :-)

Dear Friends, Pls suggest in Conditional format: e.g. A6=0 Rule Type: Use a formula to determine which cells to format Edit the rule Description: =A6=0 Format: Fill "Blue" color applies to cell range =$B$6:$X$6 but only cell B6 got highlighted with Blue instead of selected...

Dear Narayan, Thanks, what a logic used to get it done. thanks once again its done :-) Rgds, Ajinkya

Dear Friends, Could you please help to pick sheet name in a cell? Thanks.

Dear SirJB7, A bigggggggggg thanks, for sharing such a fantastic tool, you guys are really star. a query by student: is there any chances to get hacked social mail box like Gmail, yahoo etc. after installed DNT+ moral of the question, I had been using Gmail account since 3 yrs and it was...

thanks faseeh, just wanna clear 1 doubt, In your following formula "#" indecates what? =TEXT(A2-A1,"#")-(WEEKNUM(A2)-WEEKNUM(A1))*1-3 @ shrivallabha: Im learning in excel 2007, thanks for addition info. thanks

Hi Faseeh, Thanks for feedback but the output is coming 19, i think its not valid, lets check.. A1= 1-Jul-2012 A2= 31-Jul-2012 as per you, formula is... =TEXT(A2-A1,"#")-(WEEKNUM(A2)-WEEKNUM(A1))*2-3 if i cross check the output July has 31 days -5 sundays -3 holidays total 8 non...

Hi Friends, If i have 5 working days in a week then i can easily get net working days with the formula =NETWORKDAYS... but if i have 6 working days in a week and suppose 3 holidays are coming in the week, then how come i can get networking days for following period? 01-July-2012...

Hi Koushik, Yup this can be appreciated, thanks dude. Also as discussed, can we add into something like dynamic look, adding with first and last date of import, in this we can easily get the period of import and also we can get total days (max-min) Thanks Ajinkya