Counting number of "N",s

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

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
 
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
 
=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
 
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
 
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
 
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
 
Back
Top