Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: excelreturn 40,32,16,100,180 corresponding to agmt 1,2,3 without using filter and compatible to version excel 2007Re: excelreturn 40,32,16,100,180 corresponding to agmt 1,2,3Re: excelsorry 180 Re: excelwithout filter function , suitable to version 2013 and version 200Re: excelWhat more details ? I want to return 40 ,100,189 corresponding to agmt 1 and 32 corresponding to agmt2 and 16 corresponding to agmt3excel agnt n l b h Amount 1 1 2 5 2 20 1 2 5 2 20 Total 40 2 1 2 3 2 12 1 2 5 2 20 Total 32 3 1 2 4 2 16 Total 16 1 1 8 5 2 80 1 2 5 2 20 Total 100 1 1 8 10 2 160 1 2 5 2 20 Total 180 return amount while changing column column 1 (agt) Solvedexcel search by code and combine result in another sheet eg 1.1.16 search as 1.1 and 1.1.16 and combine result sw pipe 100 mm dia lead-5 km vba function search code 1.1.2 and by 1.1 and 1.1.2 and combine result of both of them vba function search code 1.1.2 and by 1.1 and 1.1.2 and combine result of both of Excel sheethow to find page number of cell that is linked from another work sheet.return page number of cell that linked from another sheets ,any vba function ?