Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count data in 2 columns
Hi All, Can Excel count data that is in two columns? Example, I have a column of people's names. In the next column, I have a number. Column A Coulmn B John Doe 10 Jane Doe 8 Mary Doe 8 John Doe 8 John Doe 8 What I'm looking for is a way to count the number of "John Doe's" and the number to the right of his name. Then the same for Mary Doe, Jane Doe, etc...etc...etc... In the end, I'll have John Doe 26, Jane Doe 8, Mary Doe 8, etc...etc... This listing will be extensive - several hundred rows long. I'm trying to summarize each instance of John Doe & all his numbers and so forth with everyone's name that is in the list. Is this possible?? Thanx. -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=546477 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only count columns if the column next to it is not blank | Excel Discussion (Misc queries) | |||
MATCH UP DATA IN COLUMNS | Excel Worksheet Functions | |||
how do I lookup data based on two columns of data | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) |