Re: $$Excel-Macros$$ Count ATM ID WITH FOURMULA

Hi try anyone of below.. =SUMPRODUCT(--($B$2:$B$820=$O11)*($C$2:$C$820=P$10)) or =COUNTIFS($B$2:$B$820,$O11,$C$2:$C$820,P$10) Thankx & Rgds, Chandra Singh Bisht Ph -: 09818724321 On Wed, Sep 10, 2014 at 12:30 PM, Saleem Ansari wrote: > Dear Sir, > > Please Find The Attachment > > Please

$$Excel-Macros$$ pls help -Required out[ut in a cell

Hi Group i m creating a macro by vba but getting some error ... pls help i want to output in a cell.using below code .. example atteched.. Private Sub CommandButton1_Click() Dim sh As Worksheet Dim rng As Range Dim i As Integer Set sh = ThisWorkbook.Sheets(1) Set rng = sh.Range("a

Re: $$Excel-Macros$$ pls help -Required out[ut in a cell

thnks ganesh..working fine.. Chandra Singh Bisht On Tue, Nov 4, 2014 at 5:01 PM, Ganesh N wrote: > Dear chandan, > > PFA. If you have any concern let me know. > > Regards, > Ganesh N > > On Tue, Nov 4, 2014 at 3:41 PM, Chandan Bisht wrote: > >> >> Hi

Re: $$Excel-Macros$$ Excel Tip

Hi. Very nice... Thankx & Rgds, Chandra Singh Bisht On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi wrote: > Convert all date in same format: > > While receiving data from different sources many time it happens that > data received is not in same format due to various reason. > > One of the

Re: $$Excel-Macros$$ Re: formula required in column c excluding Zero

Hi i think your are looking for this..file also attached =IFERROR(SMALL($B$2:$B$375,COUNTIF($B$2:$B$375,"<=0")+ROW(A1)),"") Thankx & Rgds, Chandra Singh Bisht On Wed, Apr 22, 2015 at 10:11 AM, Rajesh Agarwal wrote: > Sorry. now find the attachment. > > On Tue, Apr 21, 2015 at 10:53 PM, Raj

$$Excel-Macros$$ Fwd: Delivery Status Notification (Failure)

Hi Group Need help by vba... i have two data sheets Main and Database, and i need to pick data from database to main by to use Find function..which data not found that output should be blank. example file attached.. Thankx & Rgds, Chandra Singh Bisht -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))