Previous Topic Next Topic

Compare cels column a to column b and count

Closed
cc - Nov 9, 2010 at 12:20 PM
 cc - Nov 15, 2010 at 12:49 PM
Hello,

What i want to do is this ...

i want to count how many times the value in column b is greater than the value in column a in a range of rows. maintaining the relationship a1 to b1, a2 to b2, a3 to b3 and not something like a1 to b3, if that makes any sense.

Help please

in excel 2002 sp3
Related:

1 response

Answer 1 / 1
Hamdan
Nov 9, 2010 at 01:56 PM
If you want to find how much greater then in column C1 type =B1-A1 then just autofill the cells down . If u want to find how many times its greater then just type =B1/A1 in C1 if you want that as a percent then type =(B1/A1)*100 in C1
cc
Nov 15, 2010 at 12:49 PM
this is giving me a clue i think. what i want is to have lets say cell c200 contain the amount of times that the # in column b is greater (or less than) column a given the b1:a1,b2:a2, etc. pairings. Hope this clearer.

Similar discussions

VBA find column by name and sort
SidK -
bOFILL -

4 responses
Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response
How to compare two different columns
ABACUS -
TrowaD -

1 response