Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

2011-07-26 Thread Venkatesh Srinivas
I some how feel he need to know a bit of database basics... - Clean and organize the database before working on it... - Ensure to know the compatible formula- other features based on version and its disadvantages Regards Venkatesh +91 9841969353 On Wed, Jul 27, 2011 at 9:41 AM, XLS S

Re: $$Excel-Macros$$ vlookup query

2011-07-08 Thread Venkatesh Srinivas
please shoot your query On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE < pradeepkumar...@gmail.com> wrote: > I have a some query regarding the vlookup can somebody help > > -- > > -- > Some important links for ex

$$Excel-Macros$$ Re: Need to track minutes

2009-08-18 Thread venkatesh srinivas
can you please send at attachement with an example will be great for us to sort it ASAP On 8/18/09, Sachin Gohil wrote: > > Dear All, > > I have to maintain database of alarms received & closed, format is date & > time, and need to keep track of differences in minutes, please help. > > Thanks. >

$$Excel-Macros$$ Re: column chart

2009-08-18 Thread venkatesh srinivas
Hi Lynn! Please let me know if the below mentioned file solves our problem On 8/18/09, Lynn wrote: > > > i have the following columns > - dates > - no. of boxes packed > - no. of boxes to be packed. > > how do i do a column chart which compares the no. of boxes packed vs > to be packed ? > >

$$Excel-Macros$$ Re: Need to track minutes

2009-08-18 Thread venkatesh srinivas
hi dilip! Please fine enclosed the solve sheet.' On 8/18/09, Dilip Pandey wrote: > > Hi Sachin, > > Attached herewith is the dummy scenario with solution. Thanks. > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com >

$$Excel-Macros$$ Re: help Needed!

2009-08-12 Thread venkatesh srinivas
Hi Abdul Can you please provide an example. your file has the folloing fields Time of Call Recorded (T1) Tech.Deputed Time Tech. Arrival Time Tech. Responding Time Work Start Time Work Finish Time (T2) Restoration Time (T2-T1) Restoration Time In Mins. can you tell us what should be the final res

$$Excel-Macros$$ Re: NAMED Range

2009-08-12 Thread venkatesh srinivas
Hi Suresh! can you please give an example of us to solve the problem> might be you can add a example with your desired result.. Rgds Venkatesh On Tue, Aug 11, 2009 at 8:57 PM, suresh k wrote: > Hi All, > > I have selected A1 to A5 and given some name(In Named Range). > > Now I want to remove

$$Excel-Macros$$ Re: URGENT HELP

2009-08-02 Thread venkatesh srinivas
sorry guys.. looks like i am too late...to reply sorry ... On 8/3/09, Rajesh Janardanan wrote: > > Guys, > > I am waiting for an answer , Please respond > > Best regards > rajesh > > > On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan wrote: > >> >> Dear All, >> Need an urgent help , please ref

$$Excel-Macros$$ Re: URGENT HELP

2009-08-02 Thread venkatesh srinivas
rajesh can you confirm if the number of rows in just 13 or will it cross more than that... if its just Jan to Dec.. we can fix it with an simple {if condition.. } or else we need to find other ideas.. Regards Venkatesh On 8/3/09, Rajesh Janardanan wrote: > > > Dear All, > Need an urgent hel