hi,
i want to use the advanced filter to populate more then one field is
it posible?
for now i have an option to filter data based on one field
for example if i have
AB
AB
AC
AC
AC
AC
AD
the result will be
AB
AC
AD
but i'm trying to have is for example if i have
AB X1
AB X1
AC X2
AC X2
AC X2
AC X2
AD X3
to get
AB X1
AC X2
AD X3

is it posible and if yes if for example i have alot of fields and i
want to to use specific what should be done?