$$Excel-Macros$$ Looking For Payroll Executive / Sr. Executive

2011-12-09 Thread Rahul Gandhi
Should have Good Communication Skills and Hands on Command in Excel. Please call @ 9711772297 or Drop your resume at rahul.gan...@aol.in / rahul.gan...@videocon.com - Rahul Gandhi -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

$$Excel-Macros$$ MIS Opening

2011-08-25 Thread Rahul Gandhi
I Have 2 Off-roll Opening with me, One in Videocon as an Off-roll Employee and One in Master Franchisee of United Colors of Benetton. Package 2.5-3 Lac. Please call @ 9711772297 Regards Rahul Gandhi -- -- Some

$$Excel-Macros$$ Investment Declaration

2011-03-02 Thread Rahul Gandhi
the submit button with the help of macro automatically we receive the email from them. I know its sounds lammy but i received the above task from my boss. Regards Rahul Gandhi +91-9711772297 -- -- Some important

$$Excel-Macros$$ Re: Number sequentially, skipping blank cells

2011-01-06 Thread Rahul Gandhi
Can you please let us know what exactly you require in output On Jan 7, 4:01 am, scoobysnack88 wrote: > Does anyone have a formula or vbs to accomplish the sequential > numbering as listed here?  The rows with no information would get a > nill and the next cell would not break the number sequence

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread Rahul Gandhi.
s the breakup of amount" What actually I want is the Value which is derived from A1 should be Bold. Thanks. Rahul Gandhi On Nov 28, 9:37 pm, Dilip Pandey wrote: > Hi Rahul, > > I dont think there is any existing function using which you can bold > at text. Considering your

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread Rahul Gandhi.
Dear Team, I Checked the appendedlinks, It only shows the Format, I want my output in bold format. Thanks On Nov 29, 3:54 pm, roberto mensa wrote: > 2010/11/29 Chandra Shekar > > > Hi, > > > Pls check this site it might help you. > > >http://www.mrexcel.com/forum/showthread.php?t=20611 > > >

Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA

2010-07-23 Thread Rahul Gandhi.
I Think in particular this scenerio we have one more function of "Concatenate" or "&". that also helps us to do the same, at the other hand this formula is also very suitable for so many conditions.. Thanks again sir. On Jul 23, 6:33 pm, Dilip Pandey wrote: > Hi Hari, > > I have achieved the

Re: $$Excel-Macros$$ An Excel Query.for duplicate value)..

2010-07-23 Thread Rahul Gandhi.
Great Job Done Dilip... Regards, Rahul Gandhi On Jul 23, 6:42 pm, Dilip Pandey wrote: > You are always welcome..!! > > And formula logic is explained below:- > =OFFSET($D$1,SMALL(IF($B$2:$B$51=$G$7,ROW($B$2:$B$51),""),ROW(1:1))-1,0) > > So, I am offsetting the h

$$Excel-Macros$$ Re: Excel - Macros training in Excel 2003

2010-07-10 Thread Rahul Gandhi.
Thanks a Ton.. Nikhil That's a great Help.. On Jul 10, 10:02 pm, Nikhil Shah wrote: > Dear Friends > > Here i am sending One URL For Excel - Macro Training in excel 2003. > > http://www.familycomputerclub.com/excel/excel2003_macros.html( With Video ) > In English &  Hindi also

Re: $$Excel-Macros$$ Help: powerpoint shortcut

2010-06-25 Thread Rahul Gandhi.
you can use "powerpnt" to open the MS Powerpoint with help of run command. Regards, Rahul Gandhi +91-9711772297 On Jun 25, 9:00 am, "Rohit Garg" wrote: > Powerpnt > Regards, > > Rohit Garg-Original Message- > From: janet dickson > Sent:  2

$$Excel-Macros$$ Re: Dear Group Help Me Regarding Conditional Formating

2010-06-05 Thread Rahul Gandhi.
Please press Alt + O + D over there you can create a new rule for Conditional Formatting. Regards, Rahul Gandhi On Jun 4, 12:40 pm, Jai wrote: > Pleaese Check the Attachment > > -- > Thanks For Mail. > >  CONDITIONAL FORMATING.xlsx

Re: $$Excel-Macros$$ need VB code for Excel Macro

2010-05-24 Thread Rahul Gandhi.
I think when you are sending the mails it will ask you to press Yes to continew and no to cancel. You have to download "Express Click yes" Software to automate the program, it is easily available in Internet. Regards, Rahul Gandhi. +91-9711772297. On May 22, 11:54 pm, Prem Nara

Re: $$Excel-Macros$$ How to insert sheets name in cells

2010-05-24 Thread Rahul Gandhi.
ill work: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) To Pick the Path: =MID(CELL("filename"),1,FIND("[",CELL("filename"))-1) Regards, Rahul Gandhi. +91-9711772297 On May 24, 3:13 pm, Mahesh wrote: > Dear A

Re: $$Excel-Macros$$ Please suggest

2010-05-15 Thread Rahul Gandhi.
Dude, If you will be able to find any institute then also let me know, I also wants to Join and I am residing in Subhash Nagar. Regards, Rahul Gandhi. +91-9711772297. On May 15, 8:31 pm, ╚►♥ѕαη∂єєρ♥◄╝ wrote: > Hi All, > > I am Sandeep one of the group member like you, I am livin

Re: $$Excel-Macros$$ VLookup on Data Table

2010-05-12 Thread Rahul Gandhi.
can you please share the sample with us so that we can try on the above query. Regards, Rahul Gandhi On May 12, 12:03 pm, uu wrote: > What I would like is under column "D" to be able to select one store > number at a time from the data sort filter. What I would like to do >

Re: $$Excel-Macros$$ URGENT Request

2010-05-12 Thread Rahul Gandhi.
can you please share the example of your query On May 12, 2:33 pm, Azhar Rai wrote: > Hi Members > > I have an excel sheet with huge text data and at the beginning of each cell > text string there are names (mostly single names) I want to count the number > of letters in the first word (that is t

Re: $$Excel-Macros$$ Fwd: Brackets Before & after Words

2010-05-10 Thread Rahul Gandhi.
Or you can use the Concatenate formula to work on the same. Regards Rahul Gandhi. On May 10, 6:20 pm, big smile wrote: > > Hellow Friends. > > > Can it is possible to do the following > > > [ =C1  ] > > > I am taking the name from the C1 & I want Bracket [  

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

2010-05-07 Thread Rahul Gandhi.
2297 string, and my 14 home address is 49" Sorry Dave and Harmeet ! Regards, Rahul Gandhi +91-9711772297 On Apr 1, 4:15 pm, Dipika Mallya wrote: > Great point Paul, > > @Abhi > > To add to Paul's Excell insight with a working example, > > Suppose two functiona

$$Excel-Macros$$ CC in Mail Merge

2010-05-07 Thread Rahul Gandhi.
Guys, I wanted to add CC or Multiple Receipients in a Mail Merge. Is there be any Possiblity then please let me know. Regards Rahul Gandhi. -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ Kndly Solve my Problem

2010-05-03 Thread Rahul Gandhi.
Hey if in case you don't have the excel 2007 and you have to work on xl 2003 then you may use the concatenate or & function to work on the above fove formula. On May 2, 8:17 am, "Asheesh Arora" wrote: > Dear All, > > Please help, > > In column A:A dates are there > In column B:B Condition are th

Re: $$Excel-Macros$$ Please help me

2010-05-03 Thread Rahul Gandhi.
Can you please give me the example so that we can atleast try to help you out with query. On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know its my duty but can if any one he

Re: $$Excel-Macros$$ Please help me

2010-05-03 Thread Rahul Gandhi.
Can you please give me the example so that we can atleast try to help you out with query. On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know its my duty but can if any one he

$$Excel-Macros$$ Median in Pivot Table

2010-03-15 Thread Rahul Gandhi.
Guys, Can anyone help me to Get the Median Value in Pivot Table. Actually I am working on huge data and I have to send the any types of analysis which is based on Median Values. Please try it your end. Regards Rahul Gandhi. 9711772297

$$Excel-Macros$$ How to Extract Data from a Line written in a cell.

2010-01-18 Thread Rahul Gandhi.
= Ac No 9658489652 EMI Amt 200 Friends I have 8 Files Consisting 200 Sheets Each and Each Sheet Consists around 2 to 3 Rows of Data with the same type of Entry. Can any one please help me out to extract the data. Regards Rahul Gandhi