LinkBack URL
About LinkBacks
ejaeschk 
Hi, I am trying to calculate days since last rainfall in excel. I've tried all sorts of IF statements and cannot get it to work, I know it is something simple.
Thanks!!daysince.xls
Hi, I am trying to calculate days since last rainfall in excel. I've tried all sorts of IF statements and cannot get it to work, I know it is something simple.
Thanks!!daysince.xls
try:
=TODAY()-MAX(IF(G2:G1402<>"",A2:A1402))
Confirm Control+Shift+Enter
Last edited by RobertMika; 08-20-2013 at 10:43 AM.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
In I2 and copy down,
=ROW() - LOOKUP(9E+307, G$2:G2, ROW(G$2:G2))
----G---- ---H---- ---I---- 1 precip_mm rain/dry daysince 2 0 #N/A 3 0 #N/A 4 0 #N/A 5 0 #N/A 6 0 #N/A 7 16.2 1 0 8 0.2 1 0 9 0 1 10 0 2 11 0 3 12 0 4 13 0.2 1 0 14 0 1 15 12.4 1 0 16 0.2 1 0 17 0 1 18 0 2 19 0 3 20 28.6 1 0
Entia non sunt multiplicanda sine necessitate
Great thanks shg. Now I want to count days which have rain events more than 2 days apart, is that possible?
I don't know what that means.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks