B

#### Brian

I have five cells per line with numbers in each cell. There are hundreds of lines in the file(on same page). What I'm looking to findout are the total lines searched before I find all five values pass a "greater than or equal to" each cell in the line in question.

Here is an example:

A1 = 15

B1 = 3

C1 = 18

D1 = 8

E1 = 2

So somehow the formula or however to do this, would count howmany lines would fail until I reach a line with :

A? is >or= 15 and

B? is >or= 3 and

C? is >or= 18 and

D? is >or= 8 and

E? is >or= 2

ALL must pass on the same line(?). The result would go into another cell (say F1). Then repeat the same process for each line in the file.

I have no clue as to where to start. I have never used VBA or macros before. Maybe I'm just into something that is way over my head, but help would be appreciated.

Thanks for your time!!!!

Brian