Pull Adjacent Row Data If It Has a Certain Value

Joined
May 30, 2010
Messages
1
Reaction score
0
I have columns like this:
A
1 B
3 2
1 1 2 1
1 .5 2 .6 1
I need to build a function to pull the data from the first column based on what is in the second column.

If data from column B = 1 then pull data from row A and count it.

I want my return to be the total instances where Row B = 1 and row A <= 1.1.
The return for this instance should be 2.

Thanks
 

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