Laurence D
New Member
- Joined
- Sep 14, 2016
- Messages
- 31
Hi there,
I am wanting to create an advanced filter to sort multiple coloured columns on a filter set from A1:Z1. The spreadsheet is a document that has been created to find any issues with any of the data in the document and highlights when there is an issue. The colours are often different colours as I have distinguished them by error type but I could change this to one colour only if need be.
Is there a way to get the advanced filter to =AND each new column with sorting by colours on rows and tally them all up in the filter. That being if there is any colour on any row in the columns then it will be included in the filter and all of the rows that have no colour will be excluded from the filter.
Could someone please help me get started to get me on my way? Apologies for the lack of any code I just truly have no idea where to start!!
Thanks,
Laurence
I am wanting to create an advanced filter to sort multiple coloured columns on a filter set from A1:Z1. The spreadsheet is a document that has been created to find any issues with any of the data in the document and highlights when there is an issue. The colours are often different colours as I have distinguished them by error type but I could change this to one colour only if need be.
Is there a way to get the advanced filter to =AND each new column with sorting by colours on rows and tally them all up in the filter. That being if there is any colour on any row in the columns then it will be included in the filter and all of the rows that have no colour will be excluded from the filter.
Could someone please help me get started to get me on my way? Apologies for the lack of any code I just truly have no idea where to start!!
Thanks,
Laurence