Count formatted cells in a row?

S

sezuh

Well-known Member
Joined
Nov 19, 2010
Messages
708
Good morning GURUS,
I’ve been Googling for two night to find solution but no luck?
That is why I need your help if you don’t mind ,please.
Is there an excel formula to count the formatted cells for each row?
I would very much appreciate any suggestion in advance.
Here an example;
Sheet2


ABCDEFGHIJK
COUNT
01 05 31 3410 18 21 2815 19 25 3016 17 35 3802 03 08 0904 12 27 2913 14 24 40
01 08 34 4012 18 31 3903 05 21 2709 10 23 3613 20 28 3802 04 22 2411 14 15 1925 29 32 3306 07 16 17
01 05 06 0702 04 17 1811 13 25 3912 20 21 2416 19 27 2910 15 30 3522 28 32 3808 14 31 40
01 18 23 3605 11 24 3221 30 33 3807 08 12 1409 17 31 3525 29 37 4002 06 13 1516 19 22 3403 10 26 27
01 07 31 3616 19 28 4021 23 34 3922 26 33 3503 18 24 3705 10 15 2004 08 11 1206 13 27 32
01 17 26 3221 30 31 4013 16 18 2025 29 35 3922 27 33 3606 07 14 1902 05 12 15
01 02 07 0916 17 25 2908 18 21 2606 12 24 3413 14 32 3505 15 27 3303 19 31 4022 30 36 37
01 09 14 1607 20 34 3906 19 23 4015 18 22 3212 13 29 3605 10 25 3021 27 31 37
08 11 23 3602 06 14 2004 16 29 3103 18 22 3909 19 24 2510 15 32 3307 12 21 38
01 19 24 3602 08 21 2922 26 31 3725 30 35 4004 05 12 1703 09 16 2006 10 23 3307 11 38 3913 14 15 18
08 11 39 4003 17 26 3402 07 19 2025 27 28 3004 14 22 3606 13 24 3505 18 31 3209 12 23 38
01 04 05 0923 28 35 3602 13 24 3107 19 33 4003 10 17 1822 26 38 3906 15 29 3212 20 30 3411 16 21 2708 14 25 37
06 08 24 3005 17 23 3915 20 25 2604 07 34 3609 10 13 1602 18 28 3214 19 27 40
01 09 24 2604 05 32 3610 14 22 2307 12 39 4006 16 27 3519 20 28 3115 18 21 3308 11 25 3403 13 37 38
01 07 24 4009 17 22 2510 11 27 3403 06 21 2804 14 38 3908 12 29 3105 20 33 3615 16 18 19
05 18 28 3504 15 23 3612 19 21 3108 16 30 3403 10 24 29
01 12 21 3211 18 19 2009 13 23 3915 17 25 2803 08 33 3707 10 22 3505 14 29 3002 04 27 3824 26 34 36
07 15 27 3504 05 30 3808 10 21 3711 20 28 3403 16 39 4024 25 33 3606 09 26 2914 17 18 19
01 08 22 2702 10 24 2813 19 21 3203 04 29 3705 20 30 3909 16 31 3406 18 26 3811 17 33 3514 15 25 4007 12 23 36
01 04 29 3510 18 31 3715 16 25 2703 06 19 2008 17 22 2405 07 32 3909 13 28 3402 11 23 3012 14 21 26
01 10 22 2911 20 25 3713 18 32 3912 19 35 3602 14 26 3008 15 21 2304 07 24 2703 09 33 38
09 12 22 3905 06 25 2613 20 23 2414 18 35 3704 08 21 3103 07 11 19


<colgroup>
<col style="width: 30px; font-weight: bold;">
<col style="width: 89px;">
<col style="width: 91px;">
<col style="width: 89px;">
<col style="width: 88px;">
<col style="width: 89px;">
<col style="width: 86px;">
<col style="width: 94px;">
<col style="width: 84px;">
<col style="width: 87px;">
<col style="width: 82px;">
<col style="width: 64px;"></colgroup>
<tbody>


[TD="bgcolor: #CACACA, align: center"]1[/TD]

[TD="colspan: 2, align: center"]EXAMPLE[/TD]



[TD="bgcolor: #CACACA, align: center"]2[/TD]



[TD="bgcolor: #FFC7CE"]23 26 33 36[/TD]

[TD="bgcolor: #FFC7CE"]06 11 37 39[/TD]



[TD="bgcolor: #FFC7CE"]07 20 22 32[/TD]

[TD="align: right"]3[/TD]


[TD="bgcolor: #CACACA, align: center"]3[/TD]



[TD="bgcolor: #FFC7CE"]26 30 35 37[/TD]



[TD="align: right"]1[/TD]


[TD="bgcolor: #CACACA, align: center"]4[/TD]



[TD="bgcolor: #FFC7CE"]23 26 33 36[/TD]



[TD="bgcolor: #FFC7CE"]03 09 34 37[/TD]



[TD="align: right"]2[/TD]


[TD="bgcolor: #CACACA, align: center"]5[/TD]



[TD="bgcolor: #FFC7CE"]04 20 28 39[/TD]



[TD="align: right"]1[/TD]


[TD="bgcolor: #CACACA, align: center"]6[/TD]



[TD="bgcolor: #FFC7CE"]09 14 25 38[/TD]



[TD="bgcolor: #FFC7CE"]02 17 29 30[/TD]

[TD="align: right"]2[/TD]


[TD="bgcolor: #CACACA, align: center"]7[/TD]



[TD="bgcolor: #FFC7CE"]10 11 23 38[/TD]



[TD="bgcolor: #FFC7CE"]03 09 34 37[/TD]



[TD="bgcolor: #FFC7CE"]04 08 24 28[/TD]

[TD="align: right"]3[/TD]


[TD="bgcolor: #CACACA, align: center"]8[/TD]



[TD="bgcolor: #FFC7CE"]10 11 23 38[/TD]



[TD="bgcolor: #FFC7CE"]04 20 28 39[/TD]



[TD="align: right"]2[/TD]


[TD="bgcolor: #CACACA, align: center"]9[/TD]



[TD="bgcolor: #FFC7CE"]04 08 24 28[/TD]

[TD="bgcolor: #FFC7CE"]03 11 35 38[/TD]



[TD="bgcolor: #FFC7CE"]02 17 26 33[/TD]



[TD="align: right"]3[/TD]


[TD="bgcolor: #CACACA, align: center"]10[/TD]

[TD="bgcolor: #FFC7CE"]01 13 27 40[/TD]



[TD="bgcolor: #FFC7CE"]26 30 35 37[/TD]

[TD="bgcolor: #FFC7CE"]05 17 28 34[/TD]



[TD="align: right"]3[/TD]


[TD="bgcolor: #CACACA, align: center"]11[/TD]



[TD="bgcolor: #FFC7CE"]27 28 32 34[/TD]



[TD="align: right"]1[/TD]


[TD="bgcolor: #CACACA, align: center"]12[/TD]

[TD="bgcolor: #FFC7CE"]01 10 15 16[/TD]



[TD="bgcolor: #FFC7CE"]21 29 33 37[/TD]



[TD="align: right"]2[/TD]


[TD="bgcolor: #CACACA, align: center"]13[/TD]



[TD="align: right"]0[/TD]


[TD="bgcolor: #CACACA, align: center"]14[/TD]

[TD="bgcolor: #FFC7CE"]01 12 22 31[/TD]



[TD="bgcolor: #FFC7CE"]21 29 33 37[/TD]



[TD="bgcolor: #FFC7CE"]03 11 35 38[/TD]



[TD="align: right"]3[/TD]


[TD="bgcolor: #CACACA, align: center"]15[/TD]



[TD="bgcolor: #FFC7CE"]02 17 29 30[/TD]

[TD="align: right"]1[/TD]


[TD="bgcolor: #CACACA, align: center"]16[/TD]



[TD="bgcolor: #FFC7CE"]02 13 23 32[/TD]

[TD="bgcolor: #FFC7CE"]26 30 35 37[/TD]



[TD="align: right"]2[/TD]


[TD="bgcolor: #CACACA, align: center"]17[/TD]

[TD="bgcolor: #FFC7CE"]01 13 27 40[/TD]



[TD="bgcolor: #FFC7CE"]02 17 26 33[/TD]

[TD="bgcolor: #FFC7CE"]06 11 37 39[/TD]

[TD="bgcolor: #FFC7CE"]09 14 25 38[/TD]



[TD="bgcolor: #FFC7CE"]07 20 22 32[/TD]

[TD="align: right"]5[/TD]


[TD="bgcolor: #CACACA, align: center"]18[/TD]



[TD="bgcolor: #FFC7CE"]06 16 31 40[/TD]



[TD="align: right"]1[/TD]


[TD="bgcolor: #CACACA, align: center"]19[/TD]

[TD="bgcolor: #FFC7CE"]01 12 22 31[/TD]



[TD="bgcolor: #FFC7CE"]02 13 23 32[/TD]



[TD="align: right"]2[/TD]


[TD="bgcolor: #CACACA, align: center"]20[/TD]



[TD="align: right"]0[/TD]


[TD="bgcolor: #CACACA, align: center"]21[/TD]



[TD="bgcolor: #FFC7CE"]33 36 38 40[/TD]



[TD="align: right"]1[/TD]


[TD="bgcolor: #CACACA, align: center"]22[/TD]



[TD="bgcolor: #FFC7CE"]06 16 31 40[/TD]



[TD="bgcolor: #FFC7CE"]05 17 28 34[/TD]



[TD="align: right"]2[/TD]


[TD="bgcolor: #CACACA, align: center"]23[/TD]

[TD="bgcolor: #FFC7CE"]01 10 15 16[/TD]



[TD="bgcolor: #FFC7CE"]33 36 38 40[/TD]



[TD="bgcolor: #FFC7CE"]27 28 32 34[/TD]

[TD="bgcolor: #FFC7CE"]02 17 29 30[/TD]



[TD="align: right"]4[/TD]

</tbody>


Excel
tables to the web >> Excel Jeanie
HTML 4
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Hi,
Just to let you know,the cells formatted by selecting all data andhighlight duplicate values.
 
Upvote 0
Hi,

In K2, try:

Code: 
=SUM(IF(COUNTIF(A$2:J$23,A2:J2)>1,1))

Committed with CTRL+SHIFT+ENTER and copied down.

Matty
 
Upvote 0
Hi Matty,
Thank you very.........................................................................very,very much for help ,you have no ideas how long i've been looking for this solution, very much appreciated.....:pray::):)
Brilliant!!!!!!!
Have a Very good weekends.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
319
dshtesy
D
K
  • Question Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
600
awoohaw
awoohaw
R
  • Solved
Age Group Ranging by gender
Replies
2
Views
259
Raj1979
R
M
  • Question Question
Pivot table not showing as Numbers
Replies
1
Views
274
shift-del
shift-del
J
  • Solved
Count Values in sequence
Replies
3
Views
360
myall_blues
myall_blues

Forum statistics

Threads
1,223,911
Messages
6,175,325
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top