Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Ahmad Mustfa
kumar i got it what you sent. it's open with alt+f11 not ctrl+f11 now i want this only one specific column not on all sheet. can you please send formula for that On Mon, Feb 23, 2015 at 7:43 PM, Ahmad Mustfa wrote: > i want this in a specific column not on all sheet > > On Mon, F

Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Ahmad Mustfa
i want this in a specific column not on all sheet On Mon, Feb 23, 2015 at 7:40 PM, Ahmad Mustfa wrote: > Thanks kumar. > how you did that. i am still confused? how i can use in my work? can you > please have online chat with me. > > On Mon, Feb 23, 2015 at 7:22 PM,

Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Ahmad Mustfa
paste the following code. >>> >>> *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* >>> *Dim r As Range* >>> >>> *Set r = Selection* >>> >>> *r.ClearContents* >>> >>> *End Sub* >>> >>> Its clear the what ever

Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Ahmad Mustfa
d Sub* > > Its clear the what ever you want. > > If you need more details, please contact me @ +91 9894585740 / > bsureshkumar2...@gmail.com > > > Thanks and Regards, > Suresh Kumar.B > > > On Monday, February 23, 2015 at 11:15:49 PM UTC+5:30, Ahmad Mustfa wrot

$$Excel-Macros$$ Auto clear content

2015-02-23 Thread Ahmad Mustfa
Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-02-15 Thread Ahmad Mustfa
How can I help you raj? On 15 Feb 2015 19:55, "vidhu raj" wrote: > Hi , How are you ? > > I am Vidhuraj from Kerala, > > I am working as an accountant at ITL World Travel Management Company In > KSA, > > > > > Regards, > Vidhuraj M. > > On Friday, June 8, 2012 at 10:21:59 PM UTC+3, Ayush Jain w

Re: $$Excel-Macros$$ Count duplicate records.

2015-02-13 Thread Ahmad Mustfa
I want to count how many have attended the event both days in each class. On 13 Feb 2015 08:26, "Vaibhav Joshi" wrote: > what values do you want in col K, L & M? > > > > On Fri, Feb 13, 2015 at 6:08 AM, Ahmad Mustfa > wrote: > >> it's excel function

Re: $$Excel-Macros$$ auto move or cut copy paste function

2015-02-12 Thread Ahmad Mustfa
t; > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > >*From:* Ahmad Mustfa >

$$Excel-Macros$$ auto move or cut copy paste function

2015-02-12 Thread Ahmad Mustfa
Hi All i am looking for an auto cut copy and paste or auto move data in a column function in google spreadsheets. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of t

Re: $$Excel-Macros$$ Count duplicate records.

2015-02-12 Thread Ahmad Mustfa
macro? > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.

Re: $$Excel-Macros$$ Count duplicate records.

2015-02-12 Thread Ahmad Mustfa
A1:A10)) > > & for duplicated values: > =COUNT($A$1:$A$10)-SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)) > > Where A1 to A1o is your range of class. > > Cheers!! > > On Wed, Feb 11, 2015 at 4:30 PM, Ahmad Mustfa > wrote: > >> Hi all. >> I am looking for a

$$Excel-Macros$$ Count duplicate records.

2015-02-11 Thread Ahmad Mustfa
Hi all. I am looking for a formula to count duplicate records for a specific class/field in excel. Please help. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of thi