M
Margaret
Hello,
I have a spreadsheet with the year from 1948-1998 listed
across the first row. I have the date from 6/1 to 8/31
listed down the leftmost column. Each cell contained in
this array represents the amount of rain which fell on
that day. For instance if June 1, 1948 had 3 inches of
rain, there is a 3 in B2(the cell lining up with these
coordinates)
I need to make a list of all dates, including the year
when the rainfall meets certain criterion (greater than
1", between 0.5 and 1", etc) How can I do this?
I know which dates I need and have highlighted them using
the conditional formatting tool, but for some cases there
are over 200 dates, so I don't want to find each date
individually.
thank you very much.
Margaret
I have a spreadsheet with the year from 1948-1998 listed
across the first row. I have the date from 6/1 to 8/31
listed down the leftmost column. Each cell contained in
this array represents the amount of rain which fell on
that day. For instance if June 1, 1948 had 3 inches of
rain, there is a 3 in B2(the cell lining up with these
coordinates)
I need to make a list of all dates, including the year
when the rainfall meets certain criterion (greater than
1", between 0.5 and 1", etc) How can I do this?
I know which dates I need and have highlighted them using
the conditional formatting tool, but for some cases there
are over 200 dates, so I don't want to find each date
individually.
thank you very much.
Margaret