I have a worksheet containing many independant sets (or mini tables - not sure what the right word is) of information.
In one of the columns i want to sort and filter and highlight numbers based on criteria affecting only the numbers (up to 24) in that particular set/mini table, and ignoring the other cells/numbers in that column.
I want to do this for all the subsets/mini tables (there are up to 60 on one worksheet)
How should i go about this?
Will Inserting a Table enable me to achieve this? (which option?)
Do i need a pivot table (which option)
or a vba
In one of the columns i want to sort and filter and highlight numbers based on criteria affecting only the numbers (up to 24) in that particular set/mini table, and ignoring the other cells/numbers in that column.
I want to do this for all the subsets/mini tables (there are up to 60 on one worksheet)
How should i go about this?
Will Inserting a Table enable me to achieve this? (which option?)
Do i need a pivot table (which option)
or a vba
