I need to write a macro that counts the number of cells that have a text value in column B that matches A AND matches has a certain color. Picture attached. So for example cell B2 counts if the value of B16-B200 if they have the same name (value is the same as A2). I need to create a macro for C2-F2 that will count the number of cells that have the same name AND will count how many of those are yellow (for C2), Green (for D2), Red (e2), and blue (f2).
Được trao cho:
HI, I am good at Excel and VBA. I have referred the attachment provided. You want to get the count based on the colours and matches. Looking forward to discuss in the chat and start working on it. -Chandra
20 freelancer đang chào giá trung bình $30 cho công việc này
Experienced with that kind of projects. Advanced problem solving and analytical skills. Detail oriented and committed to accuracy. Adaptable and reliable.