$$Excel-Macros$$ Re: Help on Index and Match

2016-12-16 Thread Rajesh Janardanan
An urgent requirement ... your help would be much appreciated . On Fri, Dec 16, 2016 at 1:10 PM, Rajesh Janardanan wrote: > Folks, > > Can you please help me in using index and match in the attached sheet to > use to calculate distance between the cities ? > > regards > ra

$$Excel-Macros$$ Help on Index and Match

2016-12-16 Thread Rajesh Janardanan
Folks, Can you please help me in using index and match in the attached sheet to use to calculate distance between the cities ? regards raj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www

$$Excel-Macros$$ Help Needed on Index

2016-11-15 Thread Rajesh Janardanan
Dear All, Attached file has a small exercise done on INDEX function , Presently cells C21 to C29 has numbers, Instead of that how can I replace those cells with the names of the cities given in the table and continue using INDEX function ? Do I need to do this with a macro ? Note this is part of a

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-09-02 Thread Rajesh Janardanan
add me on +91 73567 90999 On Mon, Aug 8, 2016 at 5:13 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you >> wants to

$$Excel-Macros$$ URGENT

2014-01-19 Thread Rajesh Janardanan
Am sorry to bother you,I am in Limassol, Cyprus at the moment and I just misplaced my bag containing all my vital items, phone and money at the Bus station. I am kind of stranded now I may need a little help from you. Thanks, Rajesh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ AN URGENT HELP ON GRAPH

2012-04-22 Thread Rajesh Janardanan
.@gmail.com > -----Original Message- From: Rajesh Janardanan > Sent: Saturday, April 21, 2012 1:37 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ AN URGENT HELP ON GRAPH > > > Hi Ashish, > > This is my requirement , please advise which function

Re: $$Excel-Macros$$ AN URGENT HELP ON GRAPH

2012-04-21 Thread Rajesh Janardanan
Hi Ashish, This is my requirement , please advise which function you have used. best regards rajesh On 4/21/12, ashish koul wrote: > see if it helps choose the field from drop down in yellow cell > > > On Sat, Apr 21, 2012 at 6:52 PM, Rajesh Janardanan > wrote: > >&g

$$Excel-Macros$$ AN URGENT HELP ON GRAPH

2012-04-21 Thread Rajesh Janardanan
Hi All, Need to present a graph tomorrow and I am stuck with it ,its could be a simple excel graph question. Attached file has the trend of business performance over a period of time , I am looking for a graph ( line chart) where revenue over the period is there in the graph constant always and I

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

2010-08-31 Thread Rajesh Janardanan
Hi, I Love excel because it makes the finance manager in me to be more and more creative in financial analysis and impress my bosses. SAP/Excel helped my career in a big way :-) best regards rajesh On Tue, Aug 31, 2010 at 5:04 PM, sudhir kumar wrote: > hi , > I love excel due to its mathematic

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

2010-07-13 Thread Rajesh Janardanan
Hey Dileep, I am a CA currently in industry and planning to launch my own consultancy soon, I think macro's can be a good product for me to sell :-) , but for that I need to learn the same :-) can you tell me from where I should start ?? :-) What are the resources etc Profit share assured !! Best

Re: $$Excel-Macros$$ Graph - Question

2010-07-11 Thread Rajesh Janardanan
hello, Can any one help me on this? Best regards Rajesh On Sun, Jul 11, 2010 at 6:08 PM, Rajesh Janardanan wrote: > Hi, > > Please find attached the sample file, thanks for the help. > > Best regards > Rajesh > > On Sun, Jul 11, 2010 at 4:42 PM, Vinod N wrote: &

Re: $$Excel-Macros$$ Dashboard sheet

2010-07-11 Thread Rajesh Janardanan
Bhavya, Dashboard cant be customised , you can have financial and non financial dash board with the key figures and statistics , this is for the ready reference of the management , so purely depends on what industry u work for ... let me know if you need assistance? Best regards Rajesh On Sun, Jul

Re: $$Excel-Macros$$ Graph - Question

2010-07-11 Thread Rajesh Janardanan
Hi, Please find attached the sample file, thanks for the help. Best regards Rajesh On Sun, Jul 11, 2010 at 4:42 PM, Vinod N wrote: > Please send a sample data file.. It'll help for quick reply of your > query... > > > On Sun, Jul 11, 2010 at 6:21 PM, Rajesh Janardanan

$$Excel-Macros$$ Graph - Question

2010-07-11 Thread Rajesh Janardanan
Hi All, I need to present a graph , I have the data to be analysed for top 10 customers , over the last 12 months , that is the quantity sold over 6 months by the top 10 customers , whats the best way? I am not good in graphs and i need to present this to the chief . Please help me Thanks Best re

Re: $$Excel-Macros$$ Macro Pivotable

2010-01-20 Thread Rajesh Janardanan
Dear All, I need a quick advise , I have created an excel file and saved the same in the intranet of my company, this excel file would be accessed and updated by 2 employees on a daily basis , Can any one please advise me what are the precautions I should take when 2 employees have access to the f

$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread Rajesh Janardanan
Excellent Norman , this solved my problem, Thanks,Appreciated Best regards Rajesh On Mon, Aug 3, 2009 at 4:29 PM, Norman May wrote: > Rajesh, > > Try the formula below: > =INDEX(B1:B12,MATCH(9.99E+307,B1:B12)) > > Norman > > On Mon, Aug 3, 2009 at 1:01 AM,

$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread Rajesh Janardanan
hi Venkatesh, Can u give me a suggestion on the If command u have mentioned? Best regards rajesh On Mon, Aug 3, 2009 at 9:34 AM, Rajesh Janardanan wrote: > yes Venkatesh, it will be Jan to December only, please advise me withe > the if command > > Best regards > rajesh >

$$Excel-Macros$$ Re: URGENT HELP

2009-08-02 Thread Rajesh Janardanan
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 refer the attached file , I need a formula > which will read YTD (B13) as the last cell entered , in the a

$$Excel-Macros$$ URGENT HELP

2009-08-02 Thread Rajesh Janardanan
Dear All, Need an urgent help , please refer the attached file , I need a formula which will read YTD (B13) as the last cell entered , in the attached file B9. If I update the file for september B13 automatically should pick from B10. Please advise Best regards Rajesh --~--~-~--~~---

$$Excel-Macros$$ Re: HELP

2009-07-21 Thread Rajesh Janardanan
o that > the format and the structure can be used... > > 1. The report which you download from SAP > 2. the format in which you want the P&L, Cash Flow and the Balance > sheet.. > > Thanks > > On Jul 16, 7:42 pm, Rajesh Janardanan wrote: >> Dear All, >>

$$Excel-Macros$$ HELP

2009-07-16 Thread Rajesh Janardanan
Dear All, I need some ideas from you experts. I need to design a financial reporting package. I can download the trial balace from SAP in excel format after monthly closing and accounts have unique GL numbers , I want a package to be created where I need to get all reports populated immediately af

$$Excel-Macros$$ Re: Looking for a finance spreadsheet

2009-06-06 Thread Rajesh Janardanan
hi ryan, u sound to know debit and credit well , u can do the spreadsheet your self , please try cheers On Sat, Jun 6, 2009 at 9:51 AM, spazlon wrote: > > Hello, > > I am looking for a personal finance spreadsheet. I tried making one of > my own, but quickly realized I lacked the knowledge to d