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

Compare cels column a to column b and count
Beyond compare - Download - File management
How to convert column to row in notepad++ ✓ - Excel Forum
Excel copy column from one sheet to another automatically - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Count sentences ✓ - Programming Forum

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

Counting cells containing only numbers

VBA find column by name and sort

Counting number of times a value appears if..

Auto generate serial number in excel based on Column

Converting rows of data in notepad to columns

Similar discussions

Subscribe To Our Newsletter!