Use "group by". Example here: http://www.w3schools.com/sql/sql_groupby.asp
________________________________ From: Christopher Bodnar [mailto:[email protected]] Sent: Friday, March 05, 2010 9:36 AM To: NT System Admin Issues Subject: OT: Excel question Anyone know how to do this in Excel or Access? I've got two columns. Column A has a server name and column B has a version number. There are multiple entries for each server. What I am trying to do is query by highest version number. For example: SERVER1 2.2 SERVER1 3.4 SERVER2 2.0 SERVER2 4.2 What I'd like to return is this: SERVER1 3.4 SERVER2 4.2 Thanks Chris Bodnar, MCSE Systems Engineer Distributed Systems Service Delivery - Intel Services Guardian Life Insurance Company of America Email: [email protected] Phone: 610-807-6459 Fax: 610-807-6003 ----------------------------------------- This message, and any attachments to it, may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are notified that any use, dissemination, distribution, copying, or communication of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by return e-mail and delete the message and any attachments. Thank you. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
