I have a spreadsheet with, say, 5 columns with dozens of rows of data,
I want to show specific columns of certain rows of data based on values in one of the columns. I want to avoid doing this using a macro.
Rumour has it that I can do this using SQL but I'm a novice on that option.
I don't suppose anyone is willing/able to help?