Hey all, I am trying to compare two different columns and find a sweet spot between "Keyword Difficulty" and "Volume" In a perfect world, I'd like a high volume with a low keyword difficulty, is there a feature or formula for that? In this example, you can see words with a keyword difficulty between 0 and 70 and a volume between 20 and 480, but this list is actually thousands of words long with way of a bigger discrepancy so doing it manually would take forever.
Thanks, any help is welcomed!

Attached Images

2016-11-09_1713.png (9.7 KB, 14 views)

What constitutes a 'sweet spot'? Have you thought of dividing the volume by the difficulty (or difficulty +1, to eliminate div/o errors), then sorting by the results? I'd anticipate that getting you closer to whatever you're after.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]