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


Ignore:
Timestamp:
07/02/11 18:50:41 (10 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v171 v172  
    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)}}}
     21 * To remove duplicate rows, can create a new column with {{{=IF(A1=A2;1;0)}}}, Paste Special, Sort & Delete 1s
    2222  * http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Removing_Duplicate_Rows
    2323