How can I get maximum value from a set of goup i.e there are two to three families out of this from each family maximum age of family member is require in next colum corresponding to maximum age member. for example A xyz 45 A uyy 33 A yss 65 B sas 34 B ree 45 B ww 55 taking to abobe example maximum age from group a should releflect in next column as 65 and from goup b 55. kindly help me out to solve this issue. Thanks in advance. Vikas
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
