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
1
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.
0

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
VBA find column by name and sort
SidK -
bOFILL -

4 responses
how to count sentences in a paragraph..." using c language
gealon2024 -
indhu -

4 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses