| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting Letters in a Column
Hi folks, I have a spreadsheet where there is survey data that I need to begin analyzing. In several of the questions there were multiple choice answers that could be answered by any combination or just one letter. For example, answer 3 has many that have ABD, ABC, BCD, etc.. For analysis purposes I want to start first with the number of A's, B's, C's etc, then look at the unique combinations. Can "countif" count text entries, if so what would the formula look like? Thanks, PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=386475 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why have column letters changed to numbers in excel | Excel Discussion (Misc queries) | |||
| how do i prefix a column with letters | Excel Discussion (Misc queries) | |||
| column headings in numbers vs letters | Excel Discussion (Misc queries) | |||
| row numbers & column letters | Excel Discussion (Misc queries) | |||
| How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
