$$Excel-Macros$$ Re: Count number of columns between two values in a row

Hi Kurt, Try this: =ABS(MATCH(MAX(A1:E1),A1:E1,0)-COUNT(A1:E1)) Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com

$$Excel-Macros$$ Re: Request: A macro to check for my winning lotto numbers . . .

Hi Jim, Forgive me, if I've not understood it correctly but you can achieve the same task using Find method. Press Ctrl+F and search the number. Why you need a macro/custom formula ? Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft

Re: $$Excel-Macros$$ VBA Code Required

can you attach sample data. also is the data that you want to compare will have unique values. -- Date: Fri, 12 Nov 2010 13:09:02 +0530 Subject: $$Excel-Macros$$ VBA Code Required From: shrinivas...@gmail.com To: excel-macros@googlegroups.com Dear All Can

$$Excel-Macros$$ Help required for formule

Hello Friends I need a formula or macro( preferabley formule) need to prepare this report . I need a formula which should get the details for the account # mentioned in the column A with the reference to the currency,form the sheet DATA, if the currency is USD It should pull the value in the

Re: $$Excel-Macros$$ Calculating direction of change across several cells

First of all, you can NEVER return a 2 which represents: If every year since the max experienced a percent increase Because:  If you find the MAX of the 5 years, then check it against the following year and the following year there was an INCREASE, then evidently you didn't find the MAX correctly

Re: $$Excel-Macros$$ Help required for formule

Your formula for row 3 would look like: =IF(C3=USD,VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE)) Paul From: Jagadeesh B S jagg...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, November 17, 2010 7:45:42 AM Subject: $$Excel-Macros$$ Help required for formule Hello Friends

$$Excel-Macros$$ Re: userform, shape and ....ontime ....

no idea ? Or may i learn english before posting my questions ? lol José On 15 nov, 01:13, Alfred WALLACE jos...@gmail.com wrote: hello to all ! I'm trying to make a shape in an userform, and, to make longuer longuer this shape like a progress bar for a time duration. for exemple, my

$$Excel-Macros$$ Re: Convert PDF files to RTF File.

Hi Experts I am waiting for over 10 days for the below request to convert PDF file to RTF file format. For better understanding Please find the below. 1. Usually I will recieve n number of PDF per day. 2. I have to change the file in to RTF format (Ms WOrd). 3. Now I am open the PDF file and

$$Excel-Macros$$ IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT JAIPUR

IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT JAIPUR. PLEASE SUGGEST ME. AWAITING FOR YOUR RESPONSE. REGARDS AMIT -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ Long-waited Excel VBA coaching program is live...its worth paying

Dear Group, I quite often receive queries from the members who want to learn VBA macros but not finding resources to learn. There is a good news for such people. A Web based VBA Coaching Program is launched today by John Franco ( Same person who shared his ebooks free for this group recently).