Re: $$Excel-Macros$$ Text to collumn

Hi, The solution provided does not require a VBA code. Inbuilt facilities of Excel can do that as well. There's a feature called text to Columns in data tab in 2007 version and in data menu in previous ones. Select the first column select Text to Colums. Click on Delimited in option button click n

Re: $$Excel-Macros$$ Define a Range based on a Range object

Set xRange = Range("C1:D10") xRow = 5 Set yRange = xRange.Offset(xRow-1, 0).Resize(xRow+1, xRange.Columns.Count) CMIIW On Fri, Oct 15, 2010 at 4:06 AM, TerryP wrote: > > Given a Range object (e.g: set xRange = Range("C1:D10") ) > And given xRow = 5 , which stands for Row 5 (absolute Row inde

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

thanks for your valuble replay but i dont need countif function i need vlookup function to maping secound duplicate values only i am giving small data only so we are easily find duplicate values but data in large no of lines then what? On Oct 14, 9:06 pm, ashish koul wrote: > hi > check the att

Re: $$Excel-Macros$$ Seemingly simple thing.....

ActiveWorkbook.PrecisionAsDisplayed = True tmp() = Range("A1:A20") but, PrecisionAsDisplayed = True will change your data in your sheets On Fri, Oct 15, 2010 at 1:49 PM, The Frog wrote: > Hi everyone, > > First time posting to this group. Glad to have found it. I have a > question regarding ca

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

can you send the sample sheet On Fri, Oct 15, 2010 at 3:32 AM, renuka chari wrote: > thanks for your valuble replay > but i dont need countif function > i need vlookup function to maping secound duplicate values only i am > giving small data only so we are easily find duplicate values > but data

$$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

Dear Experts, Please solve my problem. How can we copy only filtered data in Excel. -- Thanks in advance.. Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and link

Re: $$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

Xls 2003 Select Data Copy Data Past Data Past Only Filter Data On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI wrote: > Dear Experts, > > Please solve my problem. How can we copy only filtered data in Excel. > > -- > Thanks in advance.. > Noorain Ansari > > -- > > ---

Re: $$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

Hi Noorain, Use filter then ctrl+ shift + * (*above alphabet U and I) other alternative is Advance Filter. Thanks, Saber On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI wrote: > Dear Experts, > > Please solve my problem. How can we copy only filtered data in Excel. > > -- > Thanks in advance..

Re: $$Excel-Macros$$ Time in Decimal format

just so you know: 3 hours 48 minutes is NOT 3.48 hours. it's 3.8 hours... If you're wanting the hours/minutes expressed as a decimal: =A1*24 That is:  if your time (3:48) is an actual Excel TIME and not a text string. Keep in mind that Excel doesn't store "date" and "time" it is a number th

Re: $$Excel-Macros$$ Macro Help

Thanks Its difficult to understand for me Thanks Once again - my purpose is solved Dharmesh Shah On Fri, Oct 15, 2010 at 11:44 AM, Vishal Angre wrote: > *code is Thisworkbook in VBAproject * > > > On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah > wrote: > >> Thanks Vishal >> >> Its working >>

$$Excel-Macros$$ excel to spsss

hey.is there any way to export my data in excel to spss??? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

Dear Ansari, After filtering the data,select the filtered data and then press Alt+;(Select Visible cells Only) the you can paste only the filtered data any were you want. Regards, Vijaykumar -- -- Some important l

RE: $$Excel-Macros$$ Text to collumn

Dear Anand Thanks for explanation and really nice way of explain shrinivas > Date: Thu, 14 Oct 2010 23:58:15 -0700 > Subject: Re: $$Excel-Macros$$ Text to collumn > From: anand...@gmail.com > To: excel-macros@googlegroups.com > > Hi, > > The solution provided does not require a VBA code. In

Re: $$Excel-Macros$$ Time in Decimal format

Dear Vijay After slecting your required data go to Format menu in that there are a number of formats.In the last there is Custom Format,By selecting that you can specify your own format.In that specify the format you want to have your data,Your data will be changed to the format you wanted. Reg

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

Dear Ansari, You can use Data Validation for the duplicates, Regards, Vijay On Wed, Oct 13, 2010 at 8:43 PM, vinod rao wrote: > HI > > I have multipal duplicate numbers and excluding one for others it should > say duplicate. how do i enter formula in 2003/2007 > > Thanks > Vinod > > -- > > -

$$Excel-Macros$$ excel vba opening

Hi, Prithvi Information Solutions Ltd is a global provider of enterprise solutions and services that strategically harness the power of Information Technology to help customers maximize their business values in the new economy. Prithvi has offices in USA, Canada, United Kingdom, Singapore, and Indi

Re: $$Excel-Macros$$ Time in Decimal format

Thanks a lot Srinivasan, siti, Paul and P. VijayKumar Regards, Vijay On Fri, Oct 15, 2010 at 5:28 AM, P.VIJAYKUMAR wrote: > Dear Vijay > > After slecting your required data go to Format menu in that there are a > number of formats.In the last there is Custom Format,By selecting that you > ca