Changes between Version 170 and Version 171 of UserGuidelines/GIS/Data


Ignore:
Timestamp:
07/02/11 18:48:01 (13 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UserGuidelines/GIS/Data

    v170 v171  
    1919 * The PROPER() spreadsheet function is useful to get the names in the correct format (then Paste as Text).
    2020 * 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)
     21 * To remove duplicate rows, can create a new column with {{{=IF(A1=A2;1;0)}}}
     22  * http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Removing_Duplicate_Rows
    2123
    2224Basic Hierarchy can often be found from Wikipedia (although currently there's no easy way to download this - a student project to enhance Wikipedia for this would be much appreciated!).