| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
An easier way to count equal values in two columns?
I have a worksheet with two columns, each column has a date/time value. I need to know how many of the cells in column A match the cells in column B on a row-by-row basis. Now, I could do it row by row with IF, but is there a way to look at the whole range and just count in one instance?
To clarify, the same values must only take place in the same row (e.g., A3=B3), and I'd like for the formula to return how many of those cells equal each other. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Matching cells across columns, and returning equal values | Excel Discussion (Misc queries) | |||
| Count occurances of equal values in two col. - array within SUMPRO | Excel Worksheet Functions | |||
| Determining if two columns values are equal/close | Excel Discussion (Misc queries) | |||
| Count number of values equal to MAX of a column | Excel Discussion (Misc queries) | |||
| If values in two columns are equal I want to automatically execute a macro | Excel Programming | |||
Threaded Mode
