Hi All,

I have a list of hotel IDs in one column of my spreadsheet. In the next few columns, I have ratings that customers gave the hotel for cleanliness, location, room, etc.

What I need to do is calculate the median of all the ratings for each specific hotel, in a separate column.

An example of what I have:

Hotel ID------Rating 1------Median
5555---------9
5555---------8
5555---------6 ------------Median for 5555???
4444---------8
4444---------7-------------Median for 4444???


Now, I am dealing with a very large amount of hotels, so I only want the median to be calculated once per unique Hotel ID (after all that's all I need).

How can this be done in visual basic?