Count occurences in array with condition

V

Val

Experts! See if you can help

Column I, range I200:I800
Column J, range J200:J800

I'm trying to count the number of occurences when number in column J is less
than number in column I (Values in column J are either less or equal to
values in column I) in the array. Counting when J and I are simply not equal
would work for me too. I cannot add any columns. I'm looking for solution
without using another sheet.

Any suggestion is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top