Thursday, December 30, 2010

Excel Formula Address from Vlookup magic

From a big list of address enter in single stroke. Excel magic and tricks



1. Vlookup - Enter Formula
2. $A$6 - Address name of person
3. 'D:\[Address.xls]Address'! - file location name and Sheet name
4. $B$4:$G$100 - Address range from address excel file
5. 2 - Addresses column number

Saturday, December 11, 2010

Microsoft Excel Formula: Small

You can find small number from a big list of Rows and columns. Just Follow video procedure.

You can give your suggestions for developing blog.