Hello I have a list of funds with their values on certain dates. I have created a range calculating the difference between each date for each specific fund. I would like to find (through a formula) both the date, of the biggest dropoff and increase, and the value(that dropoff/increase however must be between two non-zero numbers.) I have 4500 rows and 30 columns though so i need a formula. Thanks
My ws is laid out as follows:
1 2 3 4
A Fund# Date 1 Date2 Date3...
B 1 850000 570000 4500000
C 2 50000 650000 750000
D 3 55500 45000 60000
My ws is laid out as follows:
1 2 3 4
A Fund# Date 1 Date2 Date3...
B 1 850000 570000 4500000
C 2 50000 650000 750000
D 3 55500 45000 60000
