Changes between Version 12 and Version 13 of UserGuidelines/Importer/Excel


Ignore:
Timestamp:
03/20/20 20:54:15 (5 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UserGuidelines/Importer/Excel

    v12 v13  
    77
    88Normally this is a hidden worksheet with a user-visible UI worksheet where data is entered & 1 or more lookup worksheets.
     9
     10== Data Validation ==
     11- Data | Data Validation
     12- Custom | Formula:
     13
     14Email Address:
     15{{{
     16=ISNUMBER(MATCH("*@*.?*",A2,0))
     17}}}
    918
    1019== Lookup Lists ==
    … …  
    2736Simple L2s based on a single L1
    2837* NB Dependent Lists must be sorted by dependency
     38- L2_Start is the column header on the lookups sheet
     39- L1_Selected is the single field where L1 is selected
     40- L1s_for_L2 is the list of L1s to the left of the list of associated L2s
    2941{{{
    3042=OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1)