I often also add a "minimum" field (e.g. formula =MIN(E2,F2,G2,H2,I2,J2,K2) in Excel and filter it on a specific "minimum" position. This formula displays the lowest value within the specified range. For organic rankings, the lowest number is obviously the best rank.
For example, if neither my site nor any of my competitors rank in the top 30 or lower (the first three pages of Google), I may consider those terms to be a much lower priority. You should still analyze them, as they may be relevant, but often these end up being terms that one of those sites ranked for because of a particular piece of content, but it's not particularly relevant.
Another great way to find keywords where there is overlap with your competitors or find terms that they rank for that you don’t is through keyword gap analysis. This strategy allows you to go into one or more competitors and find terms where there is common ground or where one or more of those competitors rank and you don’t.
SEMrush
Simply type in your site and the sites you want to analyze, select the type of keywords, and get a list of those keywords.
You can also filter for a specific keyword and compare how you rank against your competitors for the term, and see which pages rank highest. You can review which pages your competitors rank highest and see what related keywords they included that you may have missed.
image.png
Unique keywords
The list below shows "unique" keywords, which are keywords that only one of the sites has rankings for, and the others don't. You can play with the advanced filters here to set parameters and see only keywords that one or more competitors have ranking for in the top 10 or 20, and your site doesn't.
Another way to segment is to look for keywords where you are “close” to the competitor but not quite at the same level yet. This keyword data can help you determine whether you should optimize existing content or create new content, but those terms should certainly be on your list. One way I use this is to look for terms where my competitor ranks in the top 5 and where the site I am analyzing ranks between 6-10.