03-21-2006, 03:27 AM
So let's say that the first letter is cell A2.
In B2 type the formula, =if(b1="",a1&a2,"")
This will give you a blank in one row and a combination in the next row.
If you have just a few combinations in column B, a series of =countif(b1:Bn,"AB") would get you your tallies. If there are quite a few, then a pivot table on column B will get you the counts.
There are, of course, other solutions!
Don
In B2 type the formula, =if(b1="",a1&a2,"")
This will give you a blank in one row and a combination in the next row.
If you have just a few combinations in column B, a series of =countif(b1:Bn,"AB") would get you your tallies. If there are quite a few, then a pivot table on column B will get you the counts.
There are, of course, other solutions!
Don