Tuesday 6 December 2011

Ms Outlook 2010 stuck on “loading profile”

This problem occurred when computers comes from “sleep”.

In case you are using the Microsoft Messenger, try to close it (at all) (from the main window, press Alt, and select File -> Exit messenger). The try to load the Outlook again. 

In case you using it and it is closed at the time where Outlook has this problem, load it!

This problem exists because the Outlook gets info about your contacts that uses Messenger also. Something is getting wrong in this communication.

Saturday 3 December 2011

Excel, how to get a value of a cell according is coordinates, like X,Y

You may wonder, why CELL formula in Excel didn't used to return a value of Cellaccording its coordinates? Well CELL formula is used to return some Properties of a referenced cell, see the help about the CELL formula.

What if you want to the a value of a cell according is coordinates, like X,Y or in Excel's worlds Column,Row number. INDEX is named the formula that can do this! It used for other purposes also, I demonstrate it for the thing we want to do.

syntax:
=INDEX(<array where will take place>;<row number>;<column number>)

example:
get the the x=1 and y=10,
with other words: the the value of the 10th row of the 1st row:
=INDEX(A:Z;10;1)

The A:Z means all the columns and row from the column A to column Z; you may define more specific are like:
=INDEX(B1:C30;10;1)
In this case, the 10th row of the 1st row will be applied in the are B1:C30.