ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help with a basic condition (https://www.excelbanter.com/excel-worksheet-functions/449002-help-basic-condition.html)

[email protected]

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.


All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com