hello again. i'm having a really hard time trying to adjust all the code online to fit my needs. i have so many criteria that need to be met so here i am!
bascially, i have several student ID results that have conditional formatting in place. I'd like to KEEP the following data but delete/hide everything else:
1) Filter out purple rows
2) WITH filtered rows: KEEP any scoreA that's 100% or less than 85%
3) Look at Score A and Score B - KEEP if the difference is greater/less than 5%
4) If a student took testB but didnt take testA, KEEP.
I've attached a spreadsheet to clear things up a little. please help! thanks in advance.
Bookmarks