[av_one_half first min_height=” vertical_alignment=” space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” border=” border_color=” radius=’0px’ padding=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” id=” custom_class=” aria_label=” av_uid=”]
[av_textblock size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=” color=” id=” custom_class=” av_uid=’av-kmzcpkmt’ admin_preview_bg=”]
Met behulp van het uitgebreide filter kun je snel en gemakkelijk een unieke lijst maken. Als we een lijstje willen maken van de unieke afdelingen ga je in het menu naar Gegevens -> Sorteren en filteren -> Geavanceerd.
- Selecteer “Kopiëren naar andere locatie”
- Lijstbereik: De kolom met de data, in dit geval cel C1 tot en met C11
- Kopiëren naar: Selecteer de locatie waar de nieuwe lijst moet komen.
- Selecteer “Alleen unieke records”.
- Klik op Ok.
[/av_textblock]
[/av_one_half][av_image src='https://lennekemeijer.nl/wp-content/uploads/2021/04/unieke-lijst-300×164.png' attachment='2060' attachment_size='medium' copyright='' caption='' styling='' align='center' font_size='' overlay_opacity='0.4' overlay_color='#000000' overlay_text_color='#ffffff' animation='no-animation' hover='' appearance='' link='' target='' title_attr='' alt_attr='' lazy_loading='disabled' id='' custom_class='' av_element_hidden_in_editor='0' av_uid='av-kmzcqd0i' admin_preview_bg=''][/av_image]
[av_one_full first min_height='' vertical_alignment='' space='' row_boxshadow='' row_boxshadow_color='' row_boxshadow_width='10' custom_margin='' margin='0px' mobile_breaking='' border='' border_color='' radius='0px' padding='0px' column_boxshadow='' column_boxshadow_color='' column_boxshadow_width='10' background='bg_color' background_color='' background_gradient_color1='' background_gradient_color2='' background_gradient_direction='vertical' src='' background_position='top left' background_repeat='no-repeat' highlight='' highlight_size='' animation='' link='' linktarget='' link_hover='' title_attr='' alt_attr='' mobile_display='' id='' custom_class='' aria_label='' av_uid='']
[av_textblock size='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' font_color='' color='' id='' custom_class='' av_uid='av-kmzctnlj' admin_preview_bg='']
Het resultaat: Een lijst met unieke afdelingen
[/av_textblock]
[/av_one_full][av_image src='https://lennekemeijer.nl/wp-content/uploads/2021/04/resultaat-unieke-lijst-300×137.png' attachment='2062' attachment_size='medium' copyright='' caption='' styling='' align='center' font_size='' overlay_opacity='0.4' overlay_color='#000000' overlay_text_color='#ffffff' animation='no-animation' hover='' appearance='' link='' target='' title_attr='' alt_attr='' lazy_loading='disabled' id='' custom_class='' av_element_hidden_in_editor='0' av_uid='av-kmzcu2zb' admin_preview_bg=''][/av_image]