Y yaparala New Member Oct 25, 2013 #1 in sheet1 having account number,type and group columns. my query is: 1. E1 get count of d1 value. ex if d1 is 121 then e1 is 16 2. g3,g4 get count of d1 value with respect of f3,f4. ex is d1 is 121 then f1 is 0 then g3 value is 15. thank for advance sreenu Attachments filter.xls 28 KB · Views: 3
in sheet1 having account number,type and group columns. my query is: 1. E1 get count of d1 value. ex if d1 is 121 then e1 is 16 2. g3,g4 get count of d1 value with respect of f3,f4. ex is d1 is 121 then f1 is 0 then g3 value is 15. thank for advance sreenu
Debraj Excel Ninja Oct 25, 2013 #2 Hi SRINIVASULU, check the attached.. if this is what you are searching for.. Attachments Chandoo#12849.xls 28.5 KB · Views: 4