If doing in Excel - Sort by Column A, insert subtotal for every change in Column A, change the function to Max, add subtotal (now Max) to column B. Now collapse the outline to level 2.
On Fri, Mar 5, 2010 at 9:36 AM, Christopher Bodnar < christopher_bod...@glic.com> wrote: > 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: christopher_bod...@glic.com > 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/> ~
