Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a source table like this:
Employee | dogs | cats | horses | |
---|---|---|---|---|
and want to have a listbox as a filter like this:
Animals
------------
dogs
cats
horses
rabbits
...
so that it returns all employees with cats, if I press cats in that listbox.
I tried it with
=if(cats='x',dual('cats',1),
if(dogs='x',dual('dogs',2),
but this ended up in garbage
any idea?
Have you thought about using CrossTable Load?
Hi,
You need use cross table.
Load your source table then advance -> advance and do this:
After that press ok and reload.