udfs

Week Numbers in Excel

Today’s author is, Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ There are four primary week numbering systems in use worldwide

See the original post here: 
Week Numbers in Excel

udfs

Formula to Access a List of Values Interspersed with Zeros or Blanks

Today’s author is Bob Umlas, an Excel MVP since 1994. This tip is a formula which enables you to access a list of values interspersed with zeros or blanks and pick up only the non-zero values in the same sequence they’re listed

Go here to read the rest:
Formula to Access a List of Values Interspersed with Zeros or Blanks

udfs

Using the VLookup Function in Excel 2007 (Visual How To)

Learn how to dynamically search table arrays in Excel 2007 using the built-in VLOOKUP function.

See the original post: 
Using the VLookup Function in Excel 2007 (Visual How To)