Context Navigation

Data

-              v199
+              v200
  * Ensure that names are consistent between Levels
  * The PROPER() spreadsheet function is useful to get the names in the correct format (then Paste as Text).
+ * The VLOOKUP() spreadsheet function is useful if the different levels of the hierarchy are in different sheets & linked via a code instead of the name (as we need)
+ * The VLOOKUP() spreadsheet function is useful if the different levels of the hierarchy are in different sheets & linked via a code instead of the name (as we need):
+  * If the lookup sheet is called 'lookup' and the lookup table is in B2-C87 then lookup code in C2 to column 2 of the lookup table: =VLOOKUP(C2; lookup.B$2:C$87; 2; 0)
  * To remove duplicate rows, can create a new column with {{{=IF(A1=A2;1;0)}}}, Paste Special, Sort & Delete 1s
   * http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Removing_Duplicate_Rows