| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing data from two columns
I have two columns of unique data, and I am trying to have Excel count the
number of instances that a cell from Column A = X and the cell from the same Row in Column B = Y (without adding columns). In other words, if Column A = Local or National and Column B = Paid or Unpaid, is there a formula that will evaluate both columns and show me how many Local Unpaid accounts I have? -- Thanks for your thoughts! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing data in two columns | Excel Worksheet Functions | |||
| Comparing data in columns | Excel Discussion (Misc queries) | |||
| Comparing columns of data | Excel Discussion (Misc queries) | |||
| Comparing two columns of data | Excel Discussion (Misc queries) | |||
| Comparing Data in 2 columns | Excel Worksheet Functions | |||
Threaded Mode
