Forum Discussion
I need some help with a better way to search the min/max value
Here´s the thing, I am an SEO Consultant and I am running a study where I compare the top 6 competitors from a client´s website, so many entries will be duplicates among the competitors and this is why I need help retrieving the min and max values from the Sheet2 into the Sheet1.
For example, the Sheet2 is the data from all 6 competitors but the data I am interested in are the ones shown in the Sheet1...
In Sheet1 - Max Vol (Col2) > This is the "Search Volume" metric int he Sheet2 (Col4)
In Sheet1 - Max Difficulty (Col3) > This is the "Keyword Difficulty" metric in Sheet2 (Col5)
In Sheet1 - Min Position (Col4) > This is the "Position" metric in Sheet2 (Col2)
In Sheet1 - URL (Col5) > This is the "URL" metric in Sheet2 (Col7)
This is Sheet1....
...and this is Sheet2...
Thoughts?
Thanks in advance!!
- I actually posted the same question in other excel resources/communities looking to get a feedback anywhere.
- Some communities don't allow crossposting.
Some allow it if you provide links to the other communities - so the helpers know if there are already solutions in the other communities.
It would be nice if you upload the workbook with the desired result.
