$$Excel-Macros$$ Re: Data Validation

2009-09-30 Thread god is gr8 i love u
Hi This is interesting solution can you plz explain how u did?? Regards Ruchi On Wed, Sep 30, 2009 at 6:15 PM, Umesh Gupta 3 wrote: > please find solved  sheet > > - Original Message - > From: Aligahk06 > To: excel-macros@googlegroups.com ; dilipan...@gmail.com > Sent: 30 September, 200

$$Excel-Macros$$ Re: Vlookup

2009-09-28 Thread god is gr8 i love u
Hi Thank you so much thats exactly i wanted Regards Ruchi On Mon, Sep 28, 2009 at 5:32 PM, Abhishek Jain wrote: > Please see the attached file. > > All I did is change the format of destination cell to "General" > > Rgrds > > On Mon, Sep 28, 2009 at 12:04 A

$$Excel-Macros$$ urgent help required in excel sheet

2009-09-20 Thread god is gr8 i love u
Hi i have attached 1 file, in this file i want to fill the frequency column i hv tried count formula but it doesnt work may be the way i m using the formula is rong plz help me Regards Ruchi --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Vlookup

2009-06-19 Thread god is gr8 i love u
Hi thank u for ur explanation u r gem man regards ruchi On Fri, Jun 19, 2009 at 4:03 PM, Dave Bonallack wrote: > Hi Ruchi, > I've tried to explain the formulas in the attachment. > Regards - Dave. > > >> Hi >> >> Thank you so much thats excatly i want it >> but can u plz explain me the formula

$$Excel-Macros$$ Re: Vlookup

2009-06-18 Thread god is gr8 i love u
ion th eintervals acc. to that >> i want to get the frequency and avg and also i hv to make chart which >> showz the counts frquency as well as avg but again in this chart i >> want to show 1 line at 2:30 which is cut of time >> so plz revert me back >> >> thank u

$$Excel-Macros$$ Re: Vlookup

2009-06-17 Thread god is gr8 i love u
again in this chart i want to show 1 line at 2:30 which is cut of time so plz revert me back thank u regards ruchi On Wed, Jun 17, 2009 at 10:11 PM, god is gr8 i love u wrote: > Hi > > oh this is gr8 > thank u > > regards > ruchi > > On Wed, Jun 17, 2009 at 5:17 PM

$$Excel-Macros$$ Re: Vlookup

2009-06-17 Thread god is gr8 i love u
adsheet. > > Thanks, > Dilipandey > -- > DILIP KUMAR PANDEY >   MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On Tue, Jun 16, 2009 at 11:08 PM, god is gr8 i love u > wro

$$Excel-Macros$$ Re: Vlookup

2009-06-16 Thread god is gr8 i love u
Hi Dilip can u plz help me to understand this query? plz elaborate it thanks regards ruchi On Tue, Jun 16, 2009 at 10:51 PM, Paul Schreiner wrote: > Well... the short answer is "Yes and No". > First, what does this have to do with the title "Vlookup"?? > > Your question is WAY too vague. >

$$Excel-Macros$$ help in making chart

2009-06-16 Thread god is gr8 i love u
HI i m sending 1 file in this i need tp find out the frequency based on different intervals and on that need to make chart which show average an frequancy based on time. plz help me regards ruchi --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ urgent help required

2009-06-12 Thread god is gr8 i love u
Hi I am ruchi gaba I hv 2 probs 1- can i open the pdf file in word without using software like pdf tranformer? 2- i hv interview on monday and VBA, MS Access ,MS excel is required in the software co. i hv dont all this in my course but the probs is my concepts are not clear specially in VBA wat

$$Excel-Macros$$ Re: how to apply color to range without using conditional formatting

2009-06-11 Thread god is gr8 i love u
hi dilip i wanna knw how u did this formating? plz tell me regards ruchi On Thu, Jun 11, 2009 at 10:53 PM, Dilip Pandey wrote: > Hi Ramesh, > > Please find attached the solved workbook. > > Thanks, > -- > DILIP KUMAR PANDEY >   MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gma

$$Excel-Macros$$ tip for the day

2009-06-05 Thread god is gr8 i love u
Hi Everyt one I am Ruchi *Tip 4 the competition* ** F11 is a shortcut for creating chart if u select the data n press F11 u will get chart on that data Try it . its good short cut Regards Ruchi --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Appreciate your help !! Keep it up !!

2009-06-04 Thread god is gr8 i love u
Hi I am really thankful to you that u made this group i m learning alot this is really gr8 i appreciate your efforts regards ruchi On Thu, Jun 4, 2009 at 10:34 PM, ayush jain wrote: > Dear members, > > I would like to recognize the efforts of few new members who are > contributing a lot in th

$$Excel-Macros$$ Re: urgent need help for excel charts

2009-06-02 Thread god is gr8 i love u
or Funds as well. > > > > Please suggest..!! > > > > Thanks > > > > -- > > DILIP KUMAR PANDEY > > MBA-HR,B COM(Hons.),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 110062 > > On Sun, May 31

$$Excel-Macros$$ Re: urgent need help for excel charts

2009-06-01 Thread god is gr8 i love u
> >> > Thanks >> > >> > -- >> > DILIP KUMAR PANDEY >> > MBA-HR,B COM(Hons.),BCA >> > Mobile: +91 9810929744 >> > dilipan...@gmail.com >> > dilipan...@yahoo.com >> > New Delhi - 110062 >> > On Sun, May 31, 2009

$$Excel-Macros$$ probs in making intervals on excel data which is in time format for making chart

2009-05-26 Thread god is gr8 i love u
Hi here i want to make chart acc. to data received here i try to make column like count n frequency so that i cn show the data on chart in which i wanted to show data acc. to intervals but i m not able to count data in time format wat cn i do? --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-21 Thread god is gr8 i love u
HI i want to make chart on data in excel its whole month data i want to show to difference in timing so which chart will b suitable and how cn i show the whole month data in chat also in this i hv 4 columns plz help me plz mail me on another id life_is_to_ch...@yahoo.co.in Thanx On Tue, May 19, 20

$$Excel-Macros$$ Re: Color Conditional Formatting

2009-04-15 Thread god is gr8 i love u
Hi I want excel dumps for certification advance excel 2007 plz help me??? On Wed, Apr 15, 2009 at 9:58 PM, Harmeet Singh wrote: > Formula dekh ke chakar aa gaye.hahahahaa > I must say awesome work. > Cheers. > > On Wed, Apr 15, 2009 at 8:33 PM, Dilip Pandey wrote: > >> Hi Surya, >>

$$Excel-Macros$$ Re: Left VLookup

2009-03-18 Thread Love
>> Add more friends to your messenger and enjoy! Invite them >> now.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/> >> >> > > > -- > Prabhakar Jain > Mumbai > > -- > Add more friends to y

$$Excel-Macros$$ Re: Single pivot for more than one sheets

2008-11-20 Thread Love
ED]> wrote: >>> >>>> Good day to all, >>>> >>>> i want to create single pivot of my data from three different excel >>>> sheets having same headers aligned uniformly in all three sheets. >>>> >>>> >>>&