find semi-duplicate rows and delete row less value?

[bsfell]

I have a spreadsheet with 559 rows and 4 columns formated like below:

Hostname User Browser Last Check-In
CEDASDANC178444 John Doe Windows Internet Explorer 7 5/24/2011 14:46
CEDASDANC178444 John Doe Windows Internet Explorer 8 5/24/2011 14:46
CEDDCAJNU155555 Jane Jill Windows Internet Explorer 8 4/7/2011 14:38

I am trying to find out what browser version my users are running. Problem is the database I extracted the data from is listing computers twice if we upgraded from Internet Explorer 7 to Internet Explorer 8. I need to remove the duplicate rows (based on the Hostname) if browser is equal to or less than Windows Internet Explorer 7, so I only see hosts with the most current browser. I hope this makes sense? I am not a programmer, so I would need instruction how to do this. Thank You So Much for anyone that can help me =)

[Fettertiger]

Hi bsfell,

to make things easy I have created a small macro in the attached file. Just copy&paste your data to the input sheet, press the button and you will find a shortlist of your input file as required in your post.

The macro will copy all data to the outputsheet, sort it by Host and Browser. Then it will loop from bottom to top and eliminate each line where the Host is identical in the row and the row above.

I did not focus on making the code as fast as possible, but tried to make it understandable for non-programmers :-)
Any feedback is appreciated

Regards

Theo

[bsfell]

Theo,

You Rock! Worked Beautifully!!! Saved me from a lot of tedious work :-)

Thanks.

Brian