Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-22 Thread NOORAIN ANSARI
Dear Rakesh, Please use it.. *=INDEX(column2,MATCH(A2,column1,0))* On Wed, Aug 22, 2012 at 5:29 PM, Rakesh Kumar Sharma wrote: > Hi Noorain, > > If i want to pick data of column2 then how it works? > > See attachment. > > > On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI > wrote: > >> Dear R

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-22 Thread Kuldeep Singh
=IFERROR(VLOOKUP(A2,'column1 data'!A:B,2,0),"") Regards, Kuldeep Singh On Wed, Aug 22, 2012 at 5:29 PM, Rakesh Kumar Sharma wrote: > Hi Noorain, > > If i want to pick data of column2 then how it works? > > See attachment. > > > On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI > wrote: > >> Dea

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-22 Thread Rakesh Kumar Sharma
Hi Noorain, If i want to pick data of column2 then how it works? See attachment. On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > See attached sheet. > > > On Fri, Aug 17, 2012 at 4:13 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Hi Noorain, >> As y

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
plz ignore On Fri, Aug 17, 2012 at 5:34 PM, Rakesh Kumar Sharma wrote: > Hi Noorain, > > As you told to use INDEX MATCH to replace VLOOKUP . > > Plz find the attached file & share how to use these > > On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> D

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
Hi Noorain, As you told to use INDEX MATCH to replace VLOOKUP . Plz find the attached file & share how to use these On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma wrote: > Dear Noorain/ Amresh, > > > Thank u so much for great helping. > > > > On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANSA

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread NOORAIN ANSARI
Dear Rakesh, See attached sheet. On Fri, Aug 17, 2012 at 4:13 PM, Rakesh Kumar Sharma wrote: > Hi Noorain, > As you told to use INDEX & MATCH to replace VLOOKUP . > plz find the attached file & share how to use these > > > On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma < > rakeshks@g

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
Hi Noorain, As you told to use INDEX & MATCH to replace VLOOKUP . plz find the attached file & share how to use these On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma wrote: > Dear Noorain/ Amresh, > > > Thank u so much for great helping. > > > > On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANS

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Rakesh Kumar Sharma
Dear Noorain/ Amresh, Thank u so much for great helping. On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > You can also set high priority of Excel exe file > See attached screen shot. > > > On Thu, Aug 16, 2012 at 4:15 PM, NOORAIN ANSARI > wrote: > >> Dear Rakesh, >> >

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread NOORAIN ANSARI
Dear Rakesh, You can do the following to speed up your workbook. 1). Save your file in .xlsb (Binary Format) to reduce size. 2).Remove unnecessary formatting. 3) Use Index Match instead of Vlookup() 4).Set Calculation Manual (Calculate only when required) 5).Use Name Ranges.

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Amresh Maurya
Hi , clear Unnecessary formatting.delete unused columns save as file type in Microsoft Binary workbook. i hope it will help you. Regards Amresh On Thu, Aug 16, 2012 at 1:08 PM, Rakesh Kumar Sharma wrote: > Dear Kuldeep, > > It's too large size > > > On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Rakesh Kumar Sharma
Dear Kuldeep, It's too large size On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep Singh wrote: > > Hi Rakesh, > > Please Share a sample worksheet. > > Regards, > Kuldeep Singh > > On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Hi Experts, >> >> I have a sh

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Kuldeep Singh
Hi Rakesh, Please Share a sample worksheet. Regards, Kuldeep Singh On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma wrote: > Hi Experts, > > I have a sheet of 70MB. I am facing problem when using formulas & filters. > It gets slow. I am using Excel 2010. Is there any way to prevent to bein

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread koul . ashish
Save the file in .xlsb format Sent on my BlackBerry® from Vodafone -Original Message- From: Rakesh Kumar Sharma Sender: excel-macros@googlegroups.com Date: Thu, 16 Aug 2012 13:01:54 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How can i reduce file size of a Ex