Excel Forum
Similar Content
Make Negative Numbers Positive in Excel and Vice Versa
Tutorial: I will show you a few ways to change negative numbers to positive numbers and back again ...
SUBTOTAL Function - Work on Filtered Data in Excel
Tutorial: Perform basic functions on a filtered dataset in excel, including SUM, AVERAGE, COUNT, COU...
Convert Scientific Notation to Numbers in Excel
Tutorial: How to convert scientific numbers to show their full amount; this method also allows you t...

Excel Magic Trick 345: Find 1st Positive number and assign 1 MATCH & COUNTIF functions

See how to find the first positive number in a list and assign the number 1. See the functions AND, COUNTIF for one formula. Then see MATCH and ROWS functions for a second formula that is an array formula.

Related video:
YTLE#104: Find 1st Positive# in Excel List

Got a Question? Ask it Here in the Forum.