• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract data with multiple criteria

J@rv!s

New Member
Hi all,

I would like to extract data from below.

I have four columns data I wants to extract something like this:
Country Google's smallest ranked domain google's smallest rank Bing's smallest ranked domain Bing's smallest rank
Russia
India
Us
England
Germany

Data:

ABing B
Bing.com C
5 D
Russia
Google Google.Ru 5 England
Bing Google.com 2 India
Bing Google.Gr 5 US
Google Google.Gr 3 Itly
Google Google.com 5 Itly
Bing Google.com 1 India
Bing Google.En 2 Germany
Google Google.com 1 England
Google Bing.Fr 4 Russia
Google Bing.com 3 England
Bing Bing.Ru 4 India
Google Google.It 5 India
Google Bing.US 2 France
Google Google.Gr 2 Germany

File is also attached for reference:

Thanks in advance
 

Attachments

  • DK.xlsx
    11.4 KB · Views: 8
..What if there is a tie for a position?

If there is a tie then I any one of from tie records. for exp.

Google Google.com 2 India
Google Google.com 2 India

I want "Google Google.com 2 India"

if there is discrepance in rank like:

Google Google.com 2 India
Google Google.com 1 India

then I want smallest ranked "Google Google.com 1 India"
 
Back
Top