I am trying to compare search result position between current search results and search result set in development.
Current Position 1
Dev Position 2
Change (-1)
(so this example shows dev work is worse than current)
Then I just diff'd these and did conditional formatting to show line-by-line what terms were the same (0), which were worse (a negative number--like the example above), and which are better (a positive number above zero).
I would like to know in an a glance how many terms stayed the same, got worse, are better. I've tried COUNTA and some tip from the site on counting within a range; but am just having a hard time groking how to do this properly.
Any insight? Thank you!
Bookmarks