| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding common data in multiple columns and rows in Excel
I'm trying to determine the number of times that certain data appears in two
columns, on the same row. For example: Below are two columns. I want to know how many times that column G has "apple" and column K has "pie". I'm only interested in knowing how many rows contain both "apple" and "pie". Column G Column K apple pie apple cider orange juice banana pudding apple pie banana bread kiwi pie apple pie orange juice kiwi juice kiwi pie orange danish apple cider orange juice apple pie orange juice kiwi juice Using the correct function(s), I should be able to get the answer; 4. But I don't know what function(s) to use. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| Select all data, multiple rows | Excel Discussion (Misc queries) | |||
Threaded Mode
