ExcelFiles_India

Dear sirs, Can you help me to find out the solution.. i have attached the xls file.. -- Thanks &

Dear sir, could you please correct this formula.. B column is Date C column is Name.. G column is

Dear sir, could please correct this formula.. SUMPRODUCT(--$A$7:$A$451>=Z34)--(--$A$7:$A$451<=

please correct the formula.. On Mon, Dec 26, 2011 at 7:00 PM, G. Ram <grs...@gmail.com> wrote:

Hi Manish This error occurs due to the limitation on Array formulas. In older versions of Excel the

Dear All I have received a file (attached)which contains an array formula given below; =SUM(IF('

hi karthik where is file section of the group , so that we can upload ebooks or other materials for

HI GROUP MEMBERS HAPPY NEW YEAR 2010

Ram here I have attached the corrected file for your reference. The problem is you have formatted the

Hi Not sure why you have a gap between "Very Good" and "Not Bad". What happens if

Excel 97-2003 file attached for those of you who have not migrated to Excel 2007. Thanks Karthik

After consolidating On Fri, Oct 30, 2009 at 5:37 PM, Mukesh Kothari <kotharim...@gmail.com

Thnak you very much MrAshish Rastogi and Mr.Nitin Baghrecha I got lot of tricks and ideals from this

Thank you Mr.Mukesh. i use the same formula now. Thanks & regards, Ram.. On Oct 16, 12:17 pm,

Excellent !!!. mr.sixth sense. i am very thankful to you. Thanks&regards, Ram.. On Oct 17, 5:36

Assume that your data (ie) Date is in A1 Cell, just paste this formula in A2 cell For getting Age by

---------- Forwarded message ---------- From: G. Ram <grs...@gmail.com> Date: Mon, Sep 28,

Hi Syed total digit / alpabets are varying from 5 to 16. But I think, if atleast 5 digit is matched

Hi, have a look cut and paste the funciton. in the given forum it will works, http://www.ozgrid.com/

This mail has solution to following post: http://www.orkut.com/Main#CommMsgs.aspx?cmm=

I do not have a ready format (had made one long back and have lost it). You can easily print on

Dear Karthik, Recently I have received the below shortcuts which are very useful. Excel 2007

We have another option to expose formulae in the worksheet use ctrl+~ and instead of numbers the

If the files you work on are huge and use function like vlookup then I would suggest use of MS Access

Hi Karthik, We hust switched to star office at work. Can I get your suggesions for StarOffice Calc

Here is a simple solution to the above problem using vlookup and some bit of logic. -- Thanks Karthik

Hi Varun For getting latest Stock prices in Excel you can use the following file... http://groups.

Hello Members, I am one of the frequent visitor of this group and this group is doing amazing. Lots

Suyog, If you have the design ogf your data share it please. my idea is like this... 1)A master file

Dear Ankur, There's one option in "page setup-headers & footers". select custom