Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a basic condition
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
I need 4 condition for condition formatting | Excel Programming |