The Deuce
[
Message Archive
|
The Deuce
]
Excel question: I have a column with a couple letters in each. Some have two sets of letters
Archived Message
Posted by Taz
on October 23, 2023, 10:33:16
Separated by an ampersand. So for example, MN, gf, pt, gf & mn, etc.
Is there a way to get excel to total each set and tell me how many there are?
Message Thread:
Excel question: I have a column with a couple letters in each. Some have two sets of letters
-
Taz
October 23, 2023, 10:33:16
I think countif works, but I don't know excel. This python would work, too...
-
illinibone
October 23, 2023, 11:02:47
Countif formula is pretty easy, if you need to delimit the data beforehand, you can*
-
reggiedunlop
October 23, 2023, 10:40:00
Ihniwtm*
-
Taz
October 23, 2023, 10:44:10
Wait I figured it out. Thanks! *
-
Taz
October 23, 2023, 10:53:08
Searching