Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread VBA VABZ
gt;> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *thameem >> *Sent:* 27 June 2013 11:15 >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Plz help me to sol

Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
e type will compress the data > in lowest possible size. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *thameem > *Sent:* 27 June 2013 11:15 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Exce

RE: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread Amit Desai (MERU)
2013 11:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob getting error as excel cannot complete this task with available resources. choose less data or close other applications On Thu, Jun 27, 2013 at 9:42 AM, Amit Desai (MERU) mailto:amit.de...@me

Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
y columns can be removed by shift + Control + Right Arrow & Delete. > > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *thameem > *Sent:* 27 June 2013 11:07 > > *To:* excel-macros@googlegroups.com > *Subjec

RE: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread Amit Desai (MERU)
l-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob Is any possibility to delete unused cells in row and column, so i can reduce load, present am using 3000 rows and 40 columns rest all rows and coloumns are empty, thank you for ur support. On Thu, Jun 27, 2013 at 9:33

Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
hameem > *Sent:* 27 June 2013 10:49 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Plz help me to solve this prob > > ** ** > > Thank you, i will follow your step, but is any other solution for this? > plz tell me, y this prob occurs

RE: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread Amit Desai (MERU)
Sent: 27 June 2013 10:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob Thank you, i will follow your step, but is any other solution for this? plz tell me, y this prob occurs, so i can take precautions in any other files. On Thu, Jun 27, 2013 at

Re: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
gt; ** ** > > Do similar steps for columnar data deletion. > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *thameem > *Sent:* 27 June 2013 10:22 > *To:* excel-macros@googlegroups.c

RE: $$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread Amit Desai (MERU)
quot;. You will not see that message.. Do similar steps for columnar data deletion. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 10:22 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Plz help me to solve this prob

$$Excel-Macros$$ Plz help me to solve this prob

2013-06-26 Thread thameem
Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want

Re: $$Excel-Macros$$ Plz Help Me

2012-08-03 Thread dguillett1
Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Anil Saxena Sent: Friday, August 03, 2012 6:28 AM To: Dilip Pandey Cc: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Plz Help Me Hi Dilip Sir, Plz find the attached file, I want the Summary Sheet do the

RE: $$Excel-Macros$$ plz, help me to drive out this sort of problem!

2012-01-26 Thread Mohammed Muneer
PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ plz, help me to drive out this sort of problem! Try this. B8 =IF(INDEX($H$1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8)=chik,INDEX($H $1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8),"") C8 =IF(INDEX($H$1:$H$1794,MAT

RE: $$Excel-Macros$$ Plz help me how can posible

2011-08-05 Thread Rajan_Verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anil Saxena Sent: Thursday, August 04, 2011 10:16 AM To: excel-macros@googlegroups.com Cc: Dilip Pandey Subject: $$Excel-Macros$$ Plz help me how can posible Hi All, Plz find the attached file and solved this

Re: $$Excel-Macros$$ Plz help me how can posible

2011-08-03 Thread Dilip Pandey
Hi, I just replied to this post, but wonder where that gone. Anil, please wait for some time and search that again. Let me know if you do not find the same, I'll send another one. Regards, DILIPandey On 8/4/11, Anil Saxena wrote: > Hi All, > Plz find the attached file and solved this query. > H

Re: $$Excel-Macros$$ plz help me Its Urgent

2010-06-23 Thread worawat kh
Dear Anil, MS word did not have pivot table function , but you can use them by insert excel object and use pivot table same as Excel. 2010/6/23 Anil Saxena > Dear Sir / Mam, > > > Do the create the excel pivot table in to MS world without copy past and > show the example ? > > -- > > --

$$Excel-Macros$$ plz help me Its Urgent

2010-06-23 Thread Anil Saxena
Dear Sir / Mam, Do the create the excel pivot table in to MS world without copy past and show the example ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twi

Re: $$Excel-Macros$$ PLZ Help Me

2010-06-12 Thread Vishal Gupta
Dear Mr. Parab, Thanks for the help. Actully you have solved a big problem of mine. Thanks again Regards Vishal Gupta On Sun, Jun 6, 2010 at 10:58 PM, Mahesh parab wrote: > Hi Vishal > > follow below mention steps > >1. Select your column A:A >2. Go to Data Validation >3. Click on s

Re: $$Excel-Macros$$ PLZ Help Me

2010-06-06 Thread Mahesh parab
Hi Vishal follow below mention steps 1. Select your column A:A 2. Go to Data Validation 3. Click on settings 4. Choose custom from drop down list 5. Enter the formula as =IF(COUNTIF(A:A,A1)>1,FALSE,TRUE) 6. Click Error Alert tab , check or select show error alert box 7. choos

$$Excel-Macros$$ PLZ Help Me

2010-06-06 Thread Vishal Gupta
Hello All, I need a command or code in excell. I want names written in a coloumn sholud not be repeated, error msg shouldbe generated when someone writes a duplicate entry. Plz help me regards Vishal Gupta -- -- Some

Re: $$Excel-Macros$$ plz help me its urgent

2010-04-09 Thread anil panchal
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote: > Hi Sir, > plz help me and Show the Formula > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twit

Re: $$Excel-Macros$$ plz help me its urgent

2010-04-09 Thread Chandra Gupta
Hello dear Please find the attached solution. Chandra Gupta Maurya On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote: > Hi Sir, > plz help me and Show the Formula > > -- > > -- > Some important links for excel user

Re: $$Excel-Macros$$ plz help me its urgent

2010-04-09 Thread Swapnil Palande
Hi Anil, Please find attached excel for solution. Regards, Swapnil. On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote: > Hi Sir, > plz help me and Show the Formula > > -- > > -- > Some important links for excel us

$$Excel-Macros$$ plz help me its urgent

2010-04-09 Thread Anil Saxena
Hi Sir, plz help me and Show the Formula -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebo

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-07 Thread rf1234 rf1234
Hello Dear, I have check it and find great.It's working nice great work. On Wed, Apr 7, 2010 at 4:56 AM, Harmeet Singh wrote: > Good one  guyz nice to see such creative formulas, here is my share of > knowledge. > Kindly check out the index match function without adding additional colu

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Harmeet Singh
Good one guyz nice to see such creative formulas, here is my share of knowledge. Kindly check out the index match function without adding additional column. Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Tue, Apr 6, 2010 at 4:59 PM, Born to Win wrote: > your welcome. > >

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Born to Win
your welcome. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena wrote: > Thanks Lot Chandrabhan Singh Ji > > > > On Tue, Apr 6, 2010 at 2:24 PM, Born to Win wrote: > >> Dear Mr. Saxena, >> >> Please find Attached file. >> >> Thanks, >> Chandrabhan Singh >> 991125

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Anil Saxena
Thanks Lot Chandrabhan Singh Ji On Tue, Apr 6, 2010 at 2:24 PM, Born to Win wrote: > Dear Mr. Saxena, > > Please find Attached file. > > Thanks, > Chandrabhan Singh > 9911255330 > > > > On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote: > >> >> >> Hi Dilip >>> plz do the needful it is urgent >>

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Sivakumar E.S
Dear Anil Saxena Find attached solution to your problem. Hope this suffies Regards Sivakumar ES On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wrote: > Hi Dilip > plz do the needful it is urgent > > I want the same ans match with ID and Questions ? > > Plz Sir show the Formula also > > > > > Re

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Abhishek Jain
You're welcome Anil. On Tue, Apr 6, 2010 at 2:09 PM, Anil Saxena wrote: > Thanks to Lot Abhishek Ji > about help me thanks > > > On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote: > >> Dear Anil, >> >> Please see the attached file. I've used an array formula. Press >> Ctrl+Shift+Enter while app

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Born to Win
Dear Mr. Saxena, Please find Attached file. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote: > > > Hi Dilip >> plz do the needful it is urgent >> >> I want the same ans match with ID and Questions ? >> >> Plz Sir show the Formula also >> >> >> >> >> Regar

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Anil Saxena
Thanks to Lot Abhishek Ji about help me thanks On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote: > Dear Anil, > > Please see the attached file. I've used an array formula. Press > Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined > the range names. > > Let me know if y

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Abhishek Jain
Dear Anil, Please see the attached file. I've used an array formula. Press Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined the range names. Let me know if you need any further help on this. Dilip's friend... :) Abhishek On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wr

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread ashish koul
check it if this helps u On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote: > > > Hi Dilip >> plz do the needful it is urgent >> >> I want the same ans match with ID and Questions ? >> >> Plz Sir show the Formula also >> >> >> >> >> Regards >> >> Anil Saxena >> >> -- >> >> ---

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Anil Saxena
Hi Dilip > plz do the needful it is urgent > > I want the same ans match with ID and Questions ? > > Plz Sir show the Formula also > > > > > Regards > > Anil Saxena > > -- > > -- > Some important links for excel users:

$$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Anil Saxena
Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER f