![]() |
|
![]() |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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! |
#2
|
||||
|
||||
![]()
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] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Neydo222 | Excel | 2 | 09-12-2015 02:49 AM |
![]() |
Inatic | Excel | 1 | 01-27-2013 08:00 AM |
![]() |
kmorrin | Excel | 4 | 06-29-2011 04:38 PM |
![]() |
Learner7 | Excel | 5 | 06-12-2010 09:54 AM |
![]() |
kgfendi | Excel | 5 | 05-16-2009 05:42 PM |