excel - Search for and sort values, return adjacent cells -

I have a large Excel spreadsheet in which there are many columns of information about events that happened to the event company, With the details in different columns (I only start with that because the column I need to search / sort is not the left column, so I do not believe I can use VLUUUUP for this). I have this sheet db (my abbreviation of "database")

In DB column G, I have a list of event place which has been used for many years.

In these DB column H, I have a formula that searches for column G, and returns several times to use each event location. If a space occurs only once, then it clearly gives 1 in a column H If this happens more than once, then the first example returns the number of events, and the other examples return zero. In this way, I have only one zero zero number for each location.

What would I like to do in another sheet (in the same workbook)? A dynamic list of the results of column H in descending order, and next to that, show the event location matching the column g. In fact, I will have a list of the most popular event places, as well as how often they are used as I add to the DB spreadsheet, this list will be automatically updated automatically.

I know that in order to "sort" the column H number, I can easily use the large number to find the largest number, then the next, etc. But problem 1 is that if two events are used in the same number of places, then it creates a problem for LARGE. Problem 2 is that I can not understand any way to return information from column G to these results.

Is this possible? Or whenever I update the list, do I have to manually sort this information? I agree with jbarker2160 that the pivot table is the way to go, however, if you actually have a standard If you want a sheet, then it should work for you.

I am going to call my second sheet DB2. Suppose in A1 the title is Times Uses and the title of B1 is the name of the place. I am also convinced that DB's title headers are also there.

Formula on DB2 cell A2 = DB! H2

Enter DB2 cell B2 formula = DB! Enter G2

Now, fill both cells in a very long way. It should be filled up to the maximum number of events, not the number of more places. Proceed with the current state of your current events, so that you do not need to fill it later after adding more entries to the DB. When you add an event to a new site, you only have to face problems, but if you can, then it is still best to avoid these kinds of problems.

Last, sort by column A, and 0 out.