Counting number of "N",s

[Bob Phillips]

=COUNTIF(1:1,"N")

--

HTH

RP
(remove nothere from the email address if mailing direct)


Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren

 

[Darren Forward]

Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren

 

[David French]

=COUNTIF(range,"n")

That should work it!

Dave French
MOS XP Master Instructor
Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren

 

[Darren Forward]

Thanks for that how would you get countif NOT to count "N" the same as "N".

Many Thanks Darren
=COUNTIF(range,"n")

That should work it!

Dave French
MOS XP Master Instructor
Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren

 

[Bob Phillips]

For that you need a UDF. See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


Thanks for that how would you get countif NOT to count "N" the same as "N".

Many Thanks Darren
=COUNTIF(range,"n")

That should work it!

Dave French
MOS XP Master Instructor
Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren

 

[Darren Forward]

Wow just what I needed.

Many Many thanks
Bob

Darren
For that you need a UDF. See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


Thanks for that how would you get countif NOT to count "N" the same as "N".

Many Thanks Darren
=COUNTIF(range,"n")

That should work it!

Dave French
MOS XP Master Instructor
Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren