|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 20th, 2006, 11:06 PM
|
|||
|
|||
Counting text strings
I have a large XLS which has columns containing multiple text initials of people separated by commas and spaces within each column such as below. I need to be able to count the number of occurrences of each initial within a column into separate cells at the base of that column. Any bright ideas?
COLUMN A IN1, BJ2, BJ3 IN1,BJ3 BJ2 BJ3 BJ2 COUNTS IN1=xxx BJ2=xxx BJ3=xxx 
|
|
#2
April 21st, 2006, 05:35 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting text strings
One way:
=COUNTIF(A1:A100,"*BJ3*") In article , 525047 wrote: I have a large XLS which has columns containing multiple text initials of people separated by commas and spaces within each column such as below. I need to be able to count the number of occurrences of each initial within a column into separate cells at the base of that column. Any bright ideas? COLUMN A IN1, BJ2, BJ3 IN1,BJ3 BJ2 BJ3 BJ2 COUNTS IN1=xxx BJ2=xxx BJ3=xxx
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
| Newbie Looking for Help | Little Penny | Using Forms | 6 | December 27th, 2005 08:33 PM |
| Newbie table Layout (Posted as suggested by Tom Lake for feedback) | Little Penny | Using Forms | 2 | December 25th, 2005 04:44 PM |
| Creating dynamic cross reference links in a Word document | torajudo | General Discussion | 4 | October 25th, 2005 03:51 PM |
| Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Linear Mode
