| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
An easier way to count equal values in two columns?
On Wednesday, December 18, 2019 at 10:00:52 AM UTC-5, Claus Busch wrote:
Hi Emilio, Am Wed, 18 Dec 2019 06:51:46 -0800 (PST) schrieb Emilio Guerra: Thank you so much, Claus. I know I'm pushing my luck and the bounds of courtesy here, but is there a way to make them count the entire column range (eg. A:A and B:B) avoiding blanks? try: =SUMPRODUCT((A1:A20=B1:B20)*(A1:A20<"")*(B1:B20< "")) Regards Claus B. -- Windows10 Office 2016 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
