So I'm trying to fill in the last column.
I need to know how many values (in the second column) in each year exceed number in the 80% column. I have a long list of dates going to 2013 or so.
Year Value Date
1957 467 01/10/1957 Year 80% of Max Number of Days when Value is greater than 80% of Max
1957 467 02/10/1957 1957 582.4
1957 467 03/10/1957 1958 1904
1957 476 04/10/1957 1959 1600
1957 487 05/10/1957 1960 3328
1957 496 06/10/1957 1961 1472
1957 501 07/10/1957 1962 1672
1957 535 08/10/1957 1963 1864
1957 541 09/10/1957 1964 1304
1957 544 10/10/1957 1965 3080
1957 524 11/10/1957 1966 1600
1957 510 12/10/1957 1967 1440
1957 510 13/10/1957 1968 1184
1957 521 14/10/1957 1969 2224
1957 530 15/10/1957 1970 3080
1957 544 16/10/1957 1971 3760
1957 561 17/10/1957 1972 2896
1957 586 18/10/1957 1973 2008
1957 626 19/10/1957 1974 2376
1957 685 20/10/1957 1975 1968
1957 728 21/10/1957 1976 1664
1957 688 22/10/1957 1977 2240
1957 651 23/10/1957 1978 1912
1957 623 24/10/1957 1979 2320
Bookmarks