$$Excel-Macros$$ Re: Plz help urgent

Try this also, =TRIM(REPLACE(A2, FIND(B2,A2),LEN(B2)+1,"")) Regards, Lalit Mohan On Monday, 17 December 2012 11:58:24 UTC+5:30, Anil Saxena wrote: > > Hi All, > plz help, I want correct email id and remove the bounce email from email > id column. > > -- > > *Anil Saxena* > > MIS Executive - R

$$Excel-Macros$$ Re: Plz help urgent

Hi Anil, Please Paste this formula into C2 and drag upto C18 =REPLACE(A2,1,LEN(B2)+1,"") Regards Prince On Monday, December 17, 2012 11:58:24 AM UTC+5:30, Anil Saxena wrote: > > Hi All, > plz help, I want correct email id and remove the bounce email from email > id column. > > -- > > *Anil Sa

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

Hi Anil, Are you looking out to create pivot table in MS Word OR you want to create pivot table in MS Excel using data source from MS Word ? I think below link might help you:- http://support.microsoft.com/kb/170745/en-us -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile:

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

Dear Vikas, Try following options:- 1) Copy the formula and move the desired cell, press Enter 2) Select the formula and select the desired cell while pressing shift key (select the desired cell with the formula cell selected ) and press Ctrl + D (to fill down the formula) OR press Ctrl + R (to

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

You are always welcome..!! -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Apr 8, 2010 at 4:26 PM, Anil Saxena wrote: > thanks lot Dilip Ji > > > On Thu, Apr 8, 2010 at 2:40 PM, Dili

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

I guess you can drag it down/across. Or select the target area after copying the formula and press Ctrl+V On Thu, Apr 8, 2010 at 2:48 PM, Vikas Chouhan wrote: > hi,, > > dear i have one problem. how to copy and paste formula because this > is array formula function.. > > > On Thu, Apr

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

hi,, dear i have one problem. how to copy and paste formula because this is array formula function.. On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey wrote: > Hi Anil, > > Attached file is solved as per your requirements. Formula is also there. > Let me know if you have any queries. > > -

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

Hi Anil, Attached file is solved as per your requirements. Formula is also there. Let me know if you have any queries. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 6, 2010 at

$$Excel-Macros$$ Re: Plz help in this problem (excel)

good reply manish - Original Message From: Ayushj To: MS EXCEL AND VBA MACROS Sent: Wed, October 14, 2009 8:36:33 AM Subject: $$Excel-Macros$$ Re: Plz help in this problem (excel) Hi Abdul, You can use ceiling function to get the desired output. CEILING(number,significance

$$Excel-Macros$$ Re: Plz help in this problem (excel)

thanks a lot On Wed, Oct 14, 2009 at 9:35 AM, vidyut more wrote: > > > use mround formula for output plz find attachment >> >> >> Input 120=mround,5) 121 122123 124 125 126127 128 129 130 >> >> >> >> i want output in this way by using round formula >> >> output 120 120 120125 125 125 125125

$$Excel-Macros$$ Re: Plz help in this problem (excel)

Hi Abdul, You can do this using the MRound function. Example: Cell A1=120 Formula: =MBOUND(A1,5) here 5 means to the nearest 5. If you want the numbers to the nearest 10 then the formula would be: =MBOUND(A1,10) Thanks, Amitabh Date: Tue, 13 Oct 2009 23:21:10 +0500 Subje

$$Excel-Macros$$ Re: Plz Help

Sorry for the wrong mail ..Jus ignore..   Vinayak Hegde > From: vinayak hegde To: excel-macros@googlegroups.com Sent: Wed, 14 October, 2009 10:22:07 AM Subject: Re: $$Excel-Macros$$ Re: Plz Help Hi Hemanth, Are you from Sirsi..?   Vinayak He

$$Excel-Macros$$ Re: Plz help in this problem (excel)

use mround formula for output plz find attachment > > > Input120=mround,5)121122123124125126127128129130 > > > > i want output in this way by using round formula > > output120120120125125125125125130130130 > > > plz send solution of this problem > Thanx in advance > > Regards, > Abdul Rasheed >

$$Excel-Macros$$ Re: Plz Help

Hi Hemanth, Are you from Sirsi..?   Vinayak Hegde > From: Hemant Hegde To: excel-macros@googlegroups.com Sent: Mon, 12 October, 2009 2:31:31 PM Subject: $$Excel-Macros$$ Re: Plz Help Hi Prashant Please find the attached solution Hemant Hegde 2009

$$Excel-Macros$$ Re: Plz help in this problem (excel)

Hi Abdul, You can use ceiling function to get the desired output. CEILING(number,significance) Example, =CEILING(121, 5) Rounds 121 up to nearest multiple of 5 i.e. 120 Let me know if it resolve your problem. Best regards, Ayush Jain On Oct 13, 11:21 pm, Abdul Rasheed wrote: > can any bod

$$Excel-Macros$$ Re: Plz Help

Hi Prashant Please find the attached solution Hemant Hegde 2009/10/11 Prashant Bhawar > > Plz help here i attached a problem file with required ans. plz help me > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > > > > -- Hemant Hegde --~--~-~--~~~---~--

$$Excel-Macros$$ Re: Plz Help

thanks harmeet its working On Sun, Oct 11, 2009 at 4:27 PM, prashant bhawar wrote: > thanks harmeet its working > > > On Sun, Oct 11, 2009 at 2:25 PM, Harmeet Singh > wrote: > >> *Tried to solve the issue in one column, i hope this helps :)**see >> attached file* >> * >> * >> >> Than

$$Excel-Macros$$ Re: Plz Help

*Tried to solve the issue in one column, i hope this helps :)**see attached file* * * Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Sun, Oct 11, 2009 at 9:30 AM, Prashant Bhawar wrote: > > Plz help here i attached a problem file with required ans. plz help me > -

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

Welcome Sandeep... just be in constant touch with the FILES section of our group... you would get relevant material from there... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth 2009/7/21 ╚►♥ѕαη∂єєρ♥◄╝ > Thanks a lot vivek !! it i

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

Thanks a lot vivek !! it is really helpful for me ..if u have or this type of file to learn functions plz send me likn or file .. and again thank u so much fnd Regards: ╚►♥ѕαη∂єєρ♥◄╝ On Tue, Jul 21, 2009 at 4:00 PM, vivek agrawal wrote: > Hi Sandeep > open this link... this is a file uploa

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

Hi Sandeep open this link... this is a file uploaded to our group..hope this helps http://excel-macros.googlegroups.com/web/39Excel2003Macros.pdf?gda=dyJxeUcAAAB2J3ijGgZtJPJc1AvLZdlBxNf0CRgjgdhSYShN3uoFr4P9yQ_zYuLTRNWtNxCtoXlhmrMR3uGvvPr01Poh-10xeV4duv6pDMGhhhZdjQlNAw Thanks Regards, Vivek Agr

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

Thank u so much vivek for writeing me ..i have scarch e book and helping material but i did not find can u plz send me link of those file i will really appreciate u for this help . Regards: ╚►♥ѕαη∂єєρ♥◄╝ On Tue, Jul 21, 2009 at 12:14 PM, vivek agrawal wrote: > hi sandeep... > pls check the files

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

hi sandeep... pls check the files of the group... there are many books and useful material... if still not satisfied... write back... will arrange for something else all the best Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth 2009/7/15 ╚►♥ѕ

$$Excel-Macros$$ Re: plz help password protected worksheet

Hello Ankur, Take a look at the link I have enclosed below http://findsarfaraz.blogspot.com/2009/06/remove-password.html Regards, Sarfaraz Ahmed On Sat, Jul 18, 2009 at 12:49 PM, ankur wrote: > > hi excel gurus > plz help in openin

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

Frnd, You can use this formula =round(A1,-2), then it will convert to nearest 100. On Wed, Jun 24, 2009 at 10:53 AM, Dilip Pandey wrote: > Hi ddp, > > It is not as big as you have presented. Try the below formula and you will > have the required result. > > =+MROUND(A3,100) > 'where A3 is the

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

Thanks Dilip, Dave. Date: Wed, 24 Jun 2009 15:39:43 +0530 Subject: $$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures From: dilipan...@gmail.com To: excel-macros@googlegroups.com Hi Dave, Below is what I found when I searched Excel 2003 help section

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

Use this formula: =ROUND(A8;-2) 2009/6/23 ddp > > Hi members, > > Hope you all are doing well. > > Please help me with a solution which, I am sure, will benefit others > too. > > Problem:It is very difficult to remember tones of figures > > Solution: It is easier to remember near

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

Thanks Deepak..this will help.. Regd, Dharmendra On 6/24/09, MOKSH.. wrote: > gud > > 2009/6/24 Deepak Gupta > >> >> Dear , >> >> use function @MROUND(FIGURE,50) >> >> >> DEEPAK >> >> On 6/23/09, Dharmendra Kumar wrote: >> > Hi members, >> > >> > Hope you all are doing well. >> > >> >

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

gud 2009/6/24 Deepak Gupta > > Dear , > > use function @MROUND(FIGURE,50) > > > DEEPAK > > On 6/23/09, Dharmendra Kumar wrote: > > Hi members, > > > > Hope you all are doing well. > > > > Please help me with a solution which, I am sure, will benefit others too. > > > > Problem: It is very

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

ver, when I type in '=+MROUND(A3,100)' to any cell, I get a #NAME? > error. > I don't see 'MROUND' in the function list, or the use of the '+' > Can you tell me what's happening please? > Regards - Dave. > > ------------------ >

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

I type in '=+MROUND(A3,100)' to any cell, I get a #NAME? > error. > I don't see 'MROUND' in the function list, or the use of the '+' > Can you tell me what's happening please? > Regards - Dave. > > ------ > Date: Wed

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

Hi Dharmendra, You can use built in MRound Function in Excel. If Cell A1 have value of 2723, MRound(A1,100) Would give you 2700. Regards, Upendra Singh 9910227325 - There are 10 ki

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

Dear , use function @MROUND(FIGURE,50) DEEPAK On 6/23/09, Dharmendra Kumar wrote: > Hi members, > > Hope you all are doing well. > > Please help me with a solution which, I am sure, will benefit others too. > > Problem: It is very difficult to remember tones of figures > > Solution:

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

ning please? Regards - Dave. Date: Wed, 24 Jun 2009 13:23:51 +0530 Subject: $$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures From: dilipan...@gmail.com To: excel-macros@googlegroups.com Hi ddp, It is not as big as you have presented. Try the below

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

Hi, You can use the ordinary rounding function. The formula would be: =ROUND(A3,-2) While '=ROUND(A3,2)' would round to 2 places LEFT of the decimal point, '=ROUND(A3,-2)' rounds numbers to 2 places RIGHT of the decimal point. Hope this helps. Regards - Dave > Date: Tue, 23 Jun 2009 10:37:34

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

Hi ddp, It is not as big as you have presented. Try the below formula and you will have the required result. =+MROUND(A3,100) 'where A3 is the reference I have tested this on a workbook and same is attached herewith for your reference. Thanks, Dilipandey -- DILIP KUMAR PANDEY MBA-HR,B COM(H