Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-09 Thread Kal xcel
Hi Sumit, I had called you several times for my previous query regarding outstanding status, but it saying number invalid. I need to speak to you. In this case, I can't use pivot table in this scenario. Because lot of other issues attached with this. I have to use formula here. Thanks Kalyan

$$Excel-Macros$$ Re: Losing weight

2010-10-09 Thread anandydr
Hi, Templates are available on Microsoft online. You can download them for free. Hope that helps. Warm regards, Anand Kumar On Oct 8, 6:44 pm, Shimmy morur...@gmail.com wrote: Hi Excellers, I am having a problem, I am trying to lose some weight, it is for tha reason that I would like to

$$Excel-Macros$$ Rupee symbol HOW ???

2010-10-09 Thread SAJID MEMON
Hi, I have done following tricks but not satisfied as : 1) Select the column/cell where you want to have the format with the new ` rupee symbol. 2) Change the format of the cell to Currency. 3) Go to Cell Format - Choose Custom and paste the following: [999]`

Re: $$Excel-Macros$$ Please help

2010-10-09 Thread rajasekhar praharaju
could you please assist me in this concern .please actually if any batch is pending using vlookup i used to find their respective names how is this possible through sumif please suggest . On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS svyas0...@gmail.com wrote: Dear Rajasekhar Please use u

Re: $$Excel-Macros$$ Rupee symbol HOW ???

2010-10-09 Thread krishna mummina
Check out here: http://bishwajeet.blogspot.com/2010/07/steps-to-include-indian-rupee-symbol.html On Sat, Oct 9, 2010 at 3:17 PM, SAJID MEMON sajidwi...@hotmail.com wrote: -- Hi, I have done following tricks but not satisfied as : 1) Select the column/cell

$$Excel-Macros$$ Simple Excel Macro ??

2010-10-09 Thread Bill Q
Hi Guys, I have been banging my head trying to figure out how to do this No luck. I am looking for a simple macro that will go to this webpage http://contests.covers.com/sportscontests/leaders.aspx?sportID=6ID=15070sRec=1eRec=50hiddenSportID=0 Will pick records 1 through 50 and copy it to

$$Excel-Macros$$ VLOOKUP function

2010-10-09 Thread Alan
I am using Excel 2007 and having a strange problem with the VLOOKUP function. I have never used it before, but I have looked at examples on the Internet. However, I cannot figure it out. I placed the following formula in Cell B2: =VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE) and then copied it to

Re: $$Excel-Macros$$ VLOOKUP function

2010-10-09 Thread Shreedar Pandurangaiah
Hi Alan, The third part of the formula, where you've put $E:$E has to be replaced by either 1 or 2(since your table array is just D and E column). Thanks, Shreedar On Sun, Oct 10, 2010 at 2:30 AM, Alan jalantho...@verizon.net wrote: I am using Excel 2007 and having a strange problem with