Hello,
In the attached file there are lists that recurring every 5 columns. Every first columns has > symbols. Firstly I neet to filtre all page by > symbol. Secondly every second columns has abbreviation name. I need to check there are abbreviation name in every second columns. After filtering for example; is there ADANA.E in all second columns or not, and for every abbreviation name which has > symbol. If the name don't continue throughout the page it must clean all row which has this name. I hope I could tell clearly. If you can help me I will be so happy.
https://www.dropbox.com/s/i3a7axbb1niir6k/Yeni Microsoft Office Excel Çalışma Sayfası.xlsx?dl=0
In the attached file there are lists that recurring every 5 columns. Every first columns has > symbols. Firstly I neet to filtre all page by > symbol. Secondly every second columns has abbreviation name. I need to check there are abbreviation name in every second columns. After filtering for example; is there ADANA.E in all second columns or not, and for every abbreviation name which has > symbol. If the name don't continue throughout the page it must clean all row which has this name. I hope I could tell clearly. If you can help me I will be so happy.
https://www.dropbox.com/s/i3a7axbb1niir6k/Yeni Microsoft Office Excel Çalışma Sayfası.xlsx?dl=0