Search results

I need to know how to compare a collumn with a cell and hide the collum the cell is in if any of the cells from the collumn do not match the cell for example IF collumn A( from A3 till end) does not = B2 hide collumn B also can this be continuosly running so that if the collum changed...

I have a table set up which lists project names their relevant buisness stream and then personal working on which projects this could be multiple. each person is a collum and can be working on multiple projects across multiple buisness streams. I have a filter set up on the buisness stream...