Clustering Rows and filtering best duplicate?

[richardio]

Hey guys,

This is my first post, what a way to pop the cherry! I have been a long time lurker and have been helped immensely by everyone here. I hope to give back as I become better with Excel.

My questions are:

I have a sheet with urls that have duplicate titles along with data on these duplicates, such as traffic data and click throughs. I am trying to cluster these rows and then highlight or fill a cell and the end of the row with the highest traffic of each cluster with "winner".

URL | Traffic | Decision
------------------------------------
xyz.com/a | 100 |
xyz.com/a | 105 | winner
xyz.com/b | 200 | winner
xyz.com/b | 105 |
------------------------------------

This is the end result I would like. I have a row number each cluster all ready, so a group of 3 duplicated would all have an index row number of 19 for example, then the next cluster would be 20. This may or may not be useful for you guys, I'm open to any suggestions.


Also, on a side note, what are some ways to improve my excel skills as analyst? Resources and such.

Thanks again!

 

[DebugGalpin]

{=MAX(IF($A$1:$A$4=A2,$B$1:$B$4))}

Remember the array part of it... Can be done by control,shift & enter

 

[richardio]

This worked perfectly, thank you. Amazed how simple that was, I had to run out and buy a book on excel and commit over the weekend.