Hi!
I`m using the filter function and want to filter visibility of multiple rows dependent on the data visible in 2 columns,
one column must have the value True, the other column must have 6XL (size).
at the moment it seems when I filter by True, the 2nd filter (size) only allows me to filter the 6XL from the True rows. However the 6XLs dont reside on the true rows but I want them visible as well...
so when either column value is present I want that row visible, either TRUE or 6XL (they are in different columns).
And how would I do this for multiple rows? say I want to filter so that any of 6 different values in 6 different columns is present? they could be a mixture of words or numbers.
best,
Bookmarks