I have dates in column A, and a series of numbers in column B, lets say temperature, with some blank cells representing zeros. The dates are in ascending order. I want to determine the first non zero temperature, and the corresponding date. The dates MUST remain in ascending order
thanks in advance
Assuming dates within A1:A10, with blank cells/temperatures within B1:B10
Place in say, C1, then array-enter the formula by pressing CTRL+SHIFT+ENTER (instead of just pressing ENTER):
=INDEX(A$1:A$10,MATCH(TRUE,$B$1:$B$10<>"",0))
Copy C1 to D1. Format C1 as date.
C1 returns the date corresponding to the 1st non blank cell within B1:B10, while D1 returns the value of that 1st non blank cell, ie the temperature.
Adapt the ranges to suit ..
Max
Singapore
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks