Counting the number of cells that contain "CH"

[LaffyAffy13]

I have 76 cells in Sheet1 that each contain 2 identification letters (all in one column). I need a way to count the cells in the column that specifically contain the two letters "CH". I need this number so that I can sort all 76 cells alphabetically and then move the range of cells containing "CH" over one column, leaving the rest in column A. I'll end up doing this for all of the identification letters, each category of letters one column over from the next, but I only need someone to help me get started, and then I can change the code to move the other letters. Sheet2 contains my desired result, but I need a macro to order these cells in case more cells labeled "CH" are later added. Can anyone help? I can try to reword this if it is too confusing.

identification_numbers.xlsm

[Jakobshavn]

How about:

=COUNTIF(A1:A76,"CH")

or if you like macros:

Please Login or Register  to view this content.

[LaffyAffy13]

Thanks man,

I'm still new to excel but yeah that worked haha

[wfm007]

Put any letter in Text Box you want to copy to next sheet