NFL schedule 2015: Week by week. The NFL released its full schedule for the 2015 season. Take a look at the matchups throughout the season.
=LARGE(B$2: B$11,ROW()-1). The dollar signs in the formula instruct Excel not to change the row numbers when I copy the formula down. The last bit of information that you'll likely want is to associate a name with the values that you've isolated.
To get the first positive or negative number in a list of data, the following formula may help you, please do as this: 1. In a blank cell besides your data, enter this array formula: =INDEX(A2:A18,MATCH(TRUE,A2:A18>0,0)), (A2:A18 is the data list that you want to use), see screenshot: 2.