Changes between Version 199 and Version 200 of UserGuidelines/GIS/Data


Ignore:
Timestamp:
05/16/12 03:52:10 (9 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v199 v200  
    2626 * Ensure that names are consistent between Levels
    2727 * The PROPER() spreadsheet function is useful to get the names in the correct format (then Paste as Text).
    28  * 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)
     28 * 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):
     29  * 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)
    2930 * To remove duplicate rows, can create a new column with {{{=IF(A1=A2;1;0)}}}, Paste Special, Sort & Delete 1s
    3031  * http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Removing_Duplicate_Rows