So I want to check the values (non-numerical) between two or three cells, in the same row but different columns, and if they are the same then apply a filter that would hide that entire row. How can you make a macros do that?
But the columns to be checked are part of a range that I have a macros that hide certain columns depending on what I want to see, so can the macros just check the cells in column that are not hidden within the desired range?
The table is A12:AK2000 and the columns range that I'd like checked is L:AK only
So, to further explain:
if I have only column L and N visible, I'd like to check every single cell (in those columns) and see if the same row cells in these columns match, and if they do, filter those values out (or hide that row) but if they don't match don't do anything to the row (especially if there is not matches rows down).
Additionally, if I were to have four columns visible, all cells in the same row must match to filter/hide that row otherwise do nothing.
Thanks!
Feel free to ask question, if I wasn't clear. I know it's a messy request![]()
Bookmarks