Help with a basic condition

J

jmbreslow

This probably has a simple answer but I'm struggling to find a solution.

I have numbers in Column A and B and I need to populate column C. In column A, I'm just checking to see if each number is equal to 1. (figures are binary in column A)

If the number in Column A is equal to 1, I want the script to check through column B, find the next number that's greater than 0, and print that number out in Column C.

Any help is much 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

Similar Threads

Mail Merge Help 1
Adding sequence numbers to paragraphs 0
Cumulative formula for word table 0
Setting column width in a table with a macro is not working 0
Excel does not accept text format! 0
List all tables, including document structure 0
Two columns followed by single page-width column on same page 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0

Top