i m comparing 3 cells with one columns with the help of sumif.I just want to autopopulate distinct value from this columns write now I am using array formula for the same but this make it file so heavy and it will take time in calculating cells if you need futher information please let me know where i enclosed my sheet.Please help as in validation if someone select TMP (is a channel name) then there city will show.if someone select another channel then there branchname will show.Please call me if you need further calirification in this my no. 9711325104
-- ---------------------------------------------------------------------------------- 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
