Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

2011-01-17 Thread solomon raju
Check this...! I worked out somethingBelieve in order... Regards, Solomon On Mon, Jan 17, 2011 at 10:46 AM, jocky Beta wrote: > > Hi, > > I made a Excel sheet with help of V lookup using the Data validation, but > my formula shows unknown error. hence pls explain me the step by > step p

$$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

2011-02-02 Thread solomon raju
Hi All, How can we extract month in text. Can someone define some formula for this. Attached my question in clear. Regards, Solomon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric

Re: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

2011-02-02 Thread solomon raju
Thank You Ashish. On Wed, Feb 2, 2011 at 2:53 PM, ashish koul wrote: > > type this in cell f5 > > =TEXT(E5,"") > > On Wed, Feb 2, 2011 at 1:09 PM, solomon raju wrote: > >> Hi All, >> >> How can we extract month in text. Can someone d

$$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT

2011-02-03 Thread solomon raju
Hi All, Please find the attached excel file and give me some formula to convert the amount in text. Regards, Solomon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

Fwd: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT

2011-02-04 Thread solomon raju
Can someone define formula because I dont know macros. Regards, Solomon -- Forwarded message -- From: solomon raju Date: Thu, Feb 3, 2011 at 3:14 PM Subject: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT To: excel-macros@googlegroups.com Hi All, Please find the attached

Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT

2011-02-05 Thread solomon raju
> Date: Sat, 5 Feb 2011 08:52:55 +0400 > Subject: Fwd: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT > > To: excel-macros@googlegroups.com > > Can someone define formula because I dont know macros. > Regards, > Solomon > > > -- Forwarded message -

$$Excel-Macros$$ HOW TO MAKE PROJECT MANAGEMENT IN EXCEL

2011-02-07 Thread solomon raju
Hi All, Can some one explain me or refer me where I get more detailed information regarding Project management in Excel. If someone know this thing with examples,kindly forward for reference. Thanks in advance Regards, Solomon -- ---

Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT

2011-02-08 Thread solomon raju
Vishal, Thank you very much. Regards, Solomon On Tue, Feb 8, 2011 at 12:19 PM, Vishal Gupta wrote: > Hi Soloman, > Try the sheet attached by me, it will definitly help you. > > Regards > CA. Vishal Gupta > 9463647598 > > > > On Thu, Feb 3, 2011 at 4:44 PM, so

Re: $$Excel-Macros$$ Change Colour of a Cell if it contains certain value

2010-08-26 Thread solomon raju
Vaibhav, You shall apply conditional formatting! Regards, Solomon On Thu, Aug 26, 2010 at 9:26 PM, Vaaibhav Jhaverr wrote: > Hello All > > It has been really nice to be a part of this group in past. Learnt many > short tricks. > > I wanted help on how to change colour of cell if it satisfies a

Re: $$Excel-Macros$$ I love excel because.......

2010-08-28 Thread solomon raju
Excel has such good features as like reporting, macros, formulas and a lot other merits which saves time and auto updates with the formulas. If we are familiar with excel it is really user friendly. Regards, Solomon On Sat, Aug 28, 2010 at 10:49 AM, Ayush wrote: > Its a very handy tool for any

Re: $$Excel-Macros$$ Excel

2010-08-28 Thread solomon raju
Nilesh, Pose your questions and many are ready to answer you friend. Regards, Solomon On Sat, Aug 28, 2010 at 10:40 AM, nilesh kapure wrote: > Hi, All, > > > > > I am fresher in ms excel & wanted to learn about basic and advance excel. > > Can someone please help me in this. > > Regards., > N

Re: $$Excel-Macros$$ Time Calulation

2010-08-30 Thread solomon raju
Hi Pankaj, If the total hours are less than the required hours that means the employee is not working 8 hours which is required as per the company policy. Hence it is reflecting the error. If the employee meets the desired criteria of 8 hours, then it is fine. Regards, Solomon. On Tue, Aug 31,

Re: $$Excel-Macros$$ extract only product name

2010-09-01 Thread solomon raju
Try this formula. Regards, Solomon On Wed, Sep 1, 2010 at 2:11 PM, Kal xcel wrote: > Dear Experts, > > I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits > Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to > extract only product name (like: Skin Fr

Re: $$Excel-Macros$$ Conditional Formating

2010-09-06 Thread solomon raju
Hi Pankaj, In Excel if you go to conditional Formatting, you can find lot of options. A conditional Formatting is like this for example, If a student scores less than 30 marks he is fail and he scores more than 30 he is pass. Conditional Formatting is like either this or that. If you didnt underst

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-11 Thread solomon raju
Hi All! I would like to learn Advanced Excel and Macros also. I know Vlookup & Hlookup and other formulas. Myself am a bit strong in excel but I want to improve more and would like to achieve more success. Please guide me! Regards, Solomon On Sat, Sep 11, 2010 at 7:26 PM, Dilip Pandey wrote: