I've spent entirely too long today trying to figure out this seemingly easy issue without any degree of success, so I'm hoping SoSH's collective wisdom can quickly point out the issue. I have a spreadsheet with two columns, one of the actual data, and then a second with a formula to check if that data has the information I want, showing an "OK" if it does, "Not OK" if it doesn't (the formula for reference is: =IF(ISNUMBER(SEARCH("FR",A3)),"OK", "Not OK"), with that being for B1, so B2 is the same but for A4, B3 is A5, etc).
All I want to do is sort by my second column so that I can get a list of the "OK"s (as that's the only data I need), but every attempt at sorting the two just completely flops. I've tried grouping the rows, I've tried every sort option there is, I just can't get the damn thing to give me a list of "OK"s that I can copy and paste and get out of there. Is there some way to do this that I've missed? Is there another obvious way to get a list of the "OK"s? I feel like this can't possibly be that complicated, but I've run out of ideas.
All I want to do is sort by my second column so that I can get a list of the "OK"s (as that's the only data I need), but every attempt at sorting the two just completely flops. I've tried grouping the rows, I've tried every sort option there is, I just can't get the damn thing to give me a list of "OK"s that I can copy and paste and get out of there. Is there some way to do this that I've missed? Is there another obvious way to get a list of the "OK"s? I feel like this can't possibly be that complicated, but I've run out of ideas.