From: RobFJ on 16 Feb 2010 06:41 I've got integer values in Rows B and C, columns 1 to 20 I'd like to be able to count the number of times where the column values in rows B and C don't match. Can someone point me in the right direction. TIA Rob
From: Max on 16 Feb 2010 07:45 B, C are columns, 1 to 20 are rows Maybe you meant to do this In say, D2: =SUMPRODUCT((B2:B20<>C2:C20))  Max Singapore  "RobFJ" wrote: > I've got integer values in Rows B and C, columns 1 to 20 > > I'd like to be able to count the number of times where the column values in > rows B and C don't match
From: Mike H on 16 Feb 2010 07:47 Hi, =SUMPRODUCT((B1:B20<>C1:C20))  Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "RobFJ" wrote: > I've got integer values in Rows B and C, columns 1 to 20 > > I'd like to be able to count the number of times where the column values in > rows B and C don't match. > > Can someone point me in the right direction. > > TIA > > > Rob > > > . >

Pages: 1 Prev: equation Next: Find a single value from tables by selecting two variable inputs? 