Friday, December 22, 2006

Implementing Arrays in Excel

One of the key things in the excel is to compare/find the values in an array....when we specify a range in any function, the excel needs to be intimated that whether we are pointing at a single cell or an array. For example, I am checking that if a single cell is having 0 or not :

If(B1:b10=0,True,False)...Suppose if I have entered the farmulae in C5....it will check if the value in B5 is 0 or not...but if we want this farmulae to check if every cell in the range b1:b10 is 0 or not....we will have to tell excel to use the range as array..for that after putting the farmulae, press ctrl+Shift+Enter rather than the traditional Enter...

Want to know more about Excel. Here are some links given by my frnd OldChippy from Excelforum.com(The Maximum Knowledge Forum)


http://www.ozgrid.com/Excel/arrays.htm
http://www.emailoffice.com/excel/arrays-bobumlas.html
http://www.personal-computer-tutor.c...ayformulas.htm
http://www.excel-vba.com/excel-27-array-formulas.htm

Thanks,
Vikas B

Thursday, December 21, 2006

Very useful information for Sum Product Function here

Do you think you are an excel expert??? May be, but if you are then please try to go to the following URL and check if you really know about this function:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Wonderful Examples of SumProducts here too :

http://homepage.ntlworld.com/ken.wright/ExSumProduct1.html

Vikas B

Free Excel Ebook Link

Please goto the following URL to get your free copy of excel. You will need to create an account to be eligible for downloading this book:

http://www.exceltip.com/LearnExcel.pdf

Regards,
Vikas B