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 ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.