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

2015-02-12 Thread Ahmad Mustfa
Thanks. Can I use vb macro in excel. If yes how. Please help. On 13 Feb 2015 02:41, "Paul Schreiner" wrote: > an excel function cannot modify another cell. > You have to use VBA macros. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the mea

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

2015-02-12 Thread Paul Schreiner
an excel function cannot modify another cell. You have to use VBA macros. 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

$$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
it's excel function. On Wed, Feb 11, 2015 at 12:47 PM, Paul Schreiner wrote: > REALLY need more infomation. > > > > > > > I was tempted to leave it at that: > ask for more info, but not say what info is needed. > > There ARE functions that CAN be used (or used in combination) to count > duplica

$$Excel-Macros$$ VBA on Webpage

2015-02-12 Thread Mandeep Baluja
Achieved code : - ieRadio.Item("radio_fulfillment")(0).Checked = True ieRadio.Item("ffModels")(0).Checked = True Achieved code Now the question is check the third tag given below. Why I am unable to click this third radio button actually when second radio button click it opens third one

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

2015-02-12 Thread Ahmad Mustfa
Thanks for the reply . good effort. Could you please see the attachment i have created actual format i wanted? On Thu, Feb 12, 2015 at 12:14 PM, Vaibhav Joshi wrote: > Hi > > check attached file: > > use follo. formula to count distinct values: > =SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)) > > & for d

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

2015-02-12 Thread Gaurav Devrani
Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant wrote: > Variables identified as type = "double" should be treated differently in > order to adjust to a expected format... > > On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani > wrote: > >> Why second line need to be

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

2015-02-12 Thread Vaibhav Joshi
Hi check attached file: use follo. formula to count distinct values: =SUMPRODUCT(1/COUNTIF(A1:A10,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: >