| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculating entries
I need assistance with:
A1 B1 C1 bob BOB ? tim TIM ? sam SAM ? tim bob tim bob My question is, I want to calculate in column C how many times Bob, Time and Sam are used in Column A. Thanks, Excel hopeless. |
|
#2
|
|||
|
|||
|
One way ..
Put in C1: =COUNTIF(A:A,B1) Copy down -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "John" wrote in message ... I need assistance with: A1 B1 C1 bob BOB ? tim TIM ? sam SAM ? tim bob tim bob My question is, I want to calculate in column C how many times Bob, Time and Sam are used in Column A. Thanks, Excel hopeless. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
| How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Linear Mode
