Participant reports | How can I filter for labels in Excel if there are multiple labels in a cell?

User manual

Getting started

Introduction to yve

First steps in yve

Event setup

Create an event

Event Navigation

Event Dashboard

Registration setup

Registration types

To Dos Checklist

Event Setup Tips

Edit event website

Event websites in yve

Customize the design

Videos, Maps & Analytics

Event community

Setup survey

Conditional questions

Answer questions

Edit and send emails

Legal requirements

Set email sender

Edit email design

Email templates

Emails and language

Create email campaign

Setup printing

Create printing

Import contacts

Import contacts

Identification and validation

Assign contacts to an event

Data protection (GDPR)

Checklist for the GDPR

Privacy statement

Data processing agreement

Lawfullness of processing

Declaration of consent

Data protection processes

Testing

Preview event website

End-to-End Test

Participant reports

Create reports about participants

Evaluation of the reports

Manage check in

Preparation for the check in

Check in participants

Manage users

Users and contacts

Groups of users

Manage account

Account settings

Deleting an account

System integration (API)

User manual as pdf

How can I filter for labels in Excel if there are multiple labels in a cell?

You can use the following formula (replace TEST with your ID and A1 with your cell):

= FIND ( "TEST", A1)

or even better:
= IF (ISERROR (FIND ( "TEST", A1)); "No", "Yes")