Count
I would like to count the cells of a column which are equal to a specific
colour of background. Can someone advise how to accomplish it. Thanks, Ray |
Count
Try Bob Phillips' nice page on this at:
http://www.xldynamic.com/source/xld.....html#counting -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Ray" wrote in message ... I would like to count the cells of a column which are equal to a specific colour of background. Can someone advise how to accomplish it. Thanks, Ray |
Count
Max,
Thanks for your pointer. However, I am not familiar with creating VBA. Is it very complicate to create? Ray "Max" wrote in message ... Try Bob Phillips' nice page on this at: http://www.xldynamic.com/source/xld.....html#counting -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Ray" wrote in message ... I would like to count the cells of a column which are equal to a specific colour of background. Can someone advise how to accomplish it. Thanks, Ray |
Count
Ray,
I've put together a sample file (~ "starter's kit") which contains an implementation of Bob Phillips' ColorIndex Function from his "Processing Coloured Cells" page at: http://www.xldynamic.com/source/xld.ColourCounter.html and some examples on how to use the UDF in Excel Here's the link to the sample file (construct details inside): http://cjoint.com/?micQQgFQvj CountCellsByFillColor_Using_BobPhillips_ColorIndex _UDF.xls Hope the sample helps to get you started .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Ray" wrote in message ... Max, Thanks for your pointer. However, I am not familiar with creating VBA. Is it very complicate to create? Ray |
Count
Max, Thanks a million for your detail and crystal clear instructions!! Learn a lot from you. Best regards, Ray "Max" wrote in message ... Ray, I've put together a sample file (~ "starter's kit") which contains an implementation of Bob Phillips' ColorIndex Function from his "Processing Coloured Cells" page at: http://www.xldynamic.com/source/xld.ColourCounter.html and some examples on how to use the UDF in Excel Here's the link to the sample file (construct details inside): http://cjoint.com/?micQQgFQvj CountCellsByFillColor_Using_BobPhillips_ColorIndex _UDF.xls Hope the sample helps to get you started .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Ray" wrote in message ... Max, Thanks for your pointer. However, I am not familiar with creating VBA. Is it very complicate to create? Ray |
Count
You're welcome, Ray !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Ray" wrote in message ... Max, Thanks a million for your detail and crystal clear instructions!! Learn a lot from you. Best regards, Ray |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com