| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting the Contents of Two Columns
Hi
I'm setting up a spreadsheet and will have two columns of text... so for instance columns A1:A5 could contain Andy Bob Chris Dave Eddie while columns D1:D5 could contain Andy Bill Colin Dave Eric What I want to do is find a way of doing a count of the number of occurrences a name appears across BOTH columns. I can do it down a single column with a Pivotable, but is there an easy way to do it down multiple columns? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
| How do I merge the contents of two columns? | Excel Discussion (Misc queries) | |||
Threaded Mode
