Re: $$Excel-Macros$$ Select numbers date wise using a formula

2011-04-01 Thread Rajesh K R
Hi I am also searching for that. u can download freely the tools & codes to crack the worksheet passwords, but in case of VBA project password cracking I think it may not be easy. Regards Rajesh kainikkara On 3/28/11, Raveendra wrote: > Can you explain how to crack password in VBThanks & R

Re: $$Excel-Macros$$ Select numbers date wise using a formula

2011-03-30 Thread C.G.Kumar
Sir, Is it possible to select two criteria. In the given case Date and Room number and then sort by date. Regards, C.G.Kumar On Fri, Mar 25, 2011 at 8:55 PM, STDEV(i) wrote: > 1. > formula HELPER > ( creating list of RowIndex ) > array formula in multi cells > =IF(ISNUMBER($A5),OFFSET(BILL!

Re: $$Excel-Macros$$ Select numbers date wise using a formula

2011-03-27 Thread Raveendra
Can you explain how to crack password in VBThanks & RegardsRaveendra -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Linked

Re: $$Excel-Macros$$ Select numbers date wise using a formula

2011-03-26 Thread STDEV(i)
please visit : http://www.cpearson.com/excel/ArrayFormulas.aspx http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx

Re: $$Excel-Macros$$ Select numbers date wise using a formula

2011-03-26 Thread Rajesh K R
Hi Dev Thank u very much for your quick reply, unfortunately I don't have any idea about array formulas. how can I learn it properly. Regards Rajesh Kainikkara On 3/25/11, STDEV(i) wrote: > 1. > formula HELPER > ( creating list of RowIndex ) > array formula in multi cells > =IF(ISNUMBER($A5),OF

$$Excel-Macros$$ Select numbers date wise using a formula

2011-03-25 Thread Rajesh K R
Hi, How can I select bill numbers of a particular date and show it in ascending order using a formula.Kindly check the attachment . Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us o