Main Profile

At A Glance

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
Length: 07:25

Contact

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

Want more info about Excel Magic Trick 345: Find 1st Positive number and assign 1 MATCH & COUNTIF functions? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question