
<!-- 

function surfto(form) {
        var myindex=document.examples_form.selectedIndex
        window.open(document.examples_form.path.value,"content");
}


function GetSelectedIndex() {
    return document.examples_form.Files.selectedIndex
}


function ShowText() {
   var selected_file=GetSelectedIndex();
   document.examples_form.description.value = "";
   document.examples_form.description.value = v_desc[selected_file];
   document.examples_form.path.value = v_path[selected_file];
}


function MakeArray(n) {
    this.length = n;
    for (var k = 1;k <= n; k++)
        this[k] = null;
} 

  var v_desc = new MakeArray(50);
  var v_path = new MakeArray(50);

  v_path[0] = "tips.shtml";
  v_desc[0] = "\r\n";

  v_path[1] = "tips017.shtml";
  v_desc[1] = "Understanding and applying Net Present Value.\r\n";

  v_path[2] = "tips018.shtml";
  v_desc[2] = "Enable ease and consistency of data entry with a dropdown list of possible entries for a range.\r\n";

  v_path[3] = "tips019.shtml";
  v_desc[3] = "How Excel workbooks become bloated and what can be done about it.\r\n";

  v_path[4] = "tips006.shtml";
  v_desc[4] = "How to sum just the numbers meeting some criteria.\r\n";

  v_path[5] = "tips007.shtml";
  v_desc[5] = "How to average just the items meeting your criteria.\r\n";

  v_path[6] = "tips101.shtml";
  v_desc[6] = "This is SUMIF on steroids ! - Plus a little insight on how array formulas work.\r\n";

  v_path[7] = "tips015.shtml";
  v_desc[7] = "Designing an array formula that functions similar to a VLOOKUP function with multiple criteria and returns a text entry.\r\n";

  v_path[8] = "tips012.shtml";
  v_desc[8] = "Returning an item from a short list.\r\n";

  v_path[9] = "tips215.shtml";
  v_desc[9] = "How to rank a list of mixed values.\r\n";

  v_path[10] = "tips009.shtml";
  v_desc[10] = "How to compare two lists and determine which items are duplicated (or not).\r\n";

  v_path[11] = "tips021.shtml";
  v_desc[11] = "Worksheet formula for counting the number of unique items in a list.\r\n";

  v_path[12] = "tips020.shtml";
  v_desc[12] = "How to use Excel's Data Validation feature to prevent duplicate entry within a range of cells.\r\n";

  v_path[13] = "tips213.shtml";
  v_desc[13] = "How to write a formula that always references the last item in a column.\r\n";

  v_path[14] = "tips010.shtml";
  v_desc[14] = "Using the OFFSET function for a maintenance-free way to show a year-to-date sum.\r\n";

  v_path[15] = "tips100.shtml";
  v_desc[15] = "How to programmatically determine how many days are in a month.\r\n";

  v_path[16] = "tips014.shtml";
  v_desc[16] = "Financial formula to return a daily growth (or loss) rate of an investment.\r\n";

  v_path[17] = "tips008.shtml";
  v_desc[17] = "How to force a line break within a cell.\r\n";

  v_path[18] = "tips214.shtml";
  v_desc[18] = "Want a quick look at all your formulas?  Here's how.\r\n";

  v_path[19] = "tips003.shtml";
  v_desc[19] = "Simple steps to hide the unused region of your spreadsheet.\r\n";

  v_path[20] = "tips004.shtml";
  v_desc[20] = "Displaying the sum of time values exceeding twenty-four hours.\r\n";

  v_path[21] = "tips013.shtml";
  v_desc[21] = "Without requiring any VBA, here's a neat worksheet technique that returns the quarter corresponding to a given date.\r\n";

  v_path[22] = "tips005.shtml";
  v_desc[22] = "Applying the ISERROR function in your fomulas to suppress #DIV/0! errors.\r\n";

  v_path[23] = "tips211.shtml";
  v_desc[23] = "Forcing a worksheet's underlying values always be exactly the same as they are displayed.\r\n";

  v_path[24] = "tips212.shtml";
  v_desc[24] = "A simple, but time-saving technique to add new data to charts.\r\n";



//-->