$$Excel-Macros$$ Help with Formula

2010-09-28 Thread harris a
Hi, I need help with formula to calculate week on week and year on year changes. for example the data is Year 8-Sep 15-Sep 22-Sep 29-Sep 2009165.60 167.80 170.80 2010174.80 174.50 174.90 Every week one data

$$Excel-Macros$$ How to open WK1 formated file with Excel 2007

2010-08-13 Thread harris a
Hello, I am not able to open lotus formatted files (with extension WK1) using Excel 2007. However, I am able to open it with Excel 2003. Please help. I have uploaded a file just now for you guys to check. thank you cheers Harris -- -

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 18 Messages in 9 Topics

2009-12-11 Thread harris a
On 12/10/09, excel-macros@googlegroups.com wrote: > = > Today's Topic Summary > = > > Group: excel-macros@googlegroups.com > Url: http://groups.go

$$Excel-Macros$$ how to hide #N/A

2009-08-05 Thread harris a
Hello, In case a formula is returning “#N/A” then is there a way by which the output of the formula could be made blank or zero. please help. regards, Harris --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: help with formula for report

2009-08-02 Thread harris a
gt; using formula. > > You have to just change the range in given macro according to your data. > > Regards, > > Swapnil. > > > > On Fri, Jul 31, 2009 at 7:52 PM, harris a wrote: > > > hello > > > thank you very much for the solution. But is it possib

$$Excel-Macros$$ Re: help with formula for report

2009-07-31 Thread harris a
n to your problem. Press update button > to run macro. > > If you have any query let me know. > > Best regards, > > Swapnil. > > > > On Fri, Jul 31, 2009 at 10:53 AM, harris a wrote: > > Hello, > > > I am enclosing file <>. I need help in populat

$$Excel-Macros$$ help with formula for report

2009-07-30 Thread harris a
Hello, I am enclosing file <>. I need help in populating the report table (Table 2). Problem explained in detail in the file. thank you regards Harris --~--~-~--~~~---~--~~ -- Some imp

$$Excel-Macros$$ Re: Help with formula

2009-07-29 Thread harris a
eople: Those who understand binary and those who > don't. > > ---­- > - > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > On Behalf Of harris a > Sent: Wednesday, July 29, 2009 3:19 PM > To: excel-macros@googlegroups.com > S

$$Excel-Macros$$ Help with formula

2009-07-29 Thread harris a
Hello, I am enclosing a file <>. In this there are two tables. Table 1 is the data table with rows and columns. Table 2 is the table in which i am requesting your help in writing the formula to populate column F with data from table 1. Formula in excel rather than VB will be helpful. thank you. r