Excel forumla

[Red Kent]

I want to do a formula were if the letter 'K' appears in a column of cells the answer is 1. If it appears twice the answer is 2, if it appears three times the answer is 3 etc etc.

 

Anyone out there that could help please.

[dorgie]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[surf]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited January 27, 2010 by surf

[pipnasty]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Red Kent]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Sir Tokyo Sexwale]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here