K Kriti New Member May 4, 2017 #26 bosco_yip said: Upload your file for us to check the problem. Regards Bosco Click to expand... I didn't make any changes to your file..
bosco_yip said: Upload your file for us to check the problem. Regards Bosco Click to expand... I didn't make any changes to your file..
B bosco_yip Excel Ninja May 4, 2017 #27 Kriti said: The whole point is to mAke it automatic? Bosco ! Click to expand... Count cell Color ways : 1] By Using VBA (post #4 indicated) - without helper column by create a module in VBE and writing code - calculation by UDF (User Define Function) 2] By Using Getcell (Macro 4 function) (post #5 indicated) - helper columns to find the color number by formula using Getcell function - calculation by formula to count specified color number 3] By Using "Filter by Color" option in "Filter" (post #14 indicated) - helper columns to fill number by hand after use "Filter by Color" - calculation by formula to count specified color number Remark : [1] and [2] automatic, [3] manual Regards Bosco
Kriti said: The whole point is to mAke it automatic? Bosco ! Click to expand... Count cell Color ways : 1] By Using VBA (post #4 indicated) - without helper column by create a module in VBE and writing code - calculation by UDF (User Define Function) 2] By Using Getcell (Macro 4 function) (post #5 indicated) - helper columns to find the color number by formula using Getcell function - calculation by formula to count specified color number 3] By Using "Filter by Color" option in "Filter" (post #14 indicated) - helper columns to fill number by hand after use "Filter by Color" - calculation by formula to count specified color number Remark : [1] and [2] automatic, [3] manual Regards Bosco
