Hello members of Mr Excel,
My puzzle presents as follows ...
I have a table that looks pretty much like the following in a sample version:
<tbody>
</tbody>
Basically, I want two things:
1. To return in successive rows (single column) the dates that correspond to those raw wherein the value in column 5 YR was greater than that in column 7 YR.
2. (related to the previous) To return in a single cell, the count of the number of rows wherein (again) the value in column 5 YR was greater than that in column 7 YR.
I think that the idea it's simple but I cannot get my head around it. I have been trying VLOOKUP, INDEX, MATH, COUNTIF, etc, but I was unsuccessful to date.
Thank you for your help!
My puzzle presents as follows ...
I have a table that looks pretty much like the following in a sample version:
Date | 1 MO | 2 MO | 3 MO | 6 MO | 1 YR | 2 YR | 3 YR | 5 YR | 7 YR | 10 YR | 20 YR | 30 YR |
######## | 2.41 | 2.42 | 2.39 | 2.54 | 2.62 | 2.63 | 2.61 | 2.64 | 2.72 | 2.79 | 2.92 | 3.03 |
######## | 2.31 | 2.33 | 2.37 | 2.52 | 2.7 | 2.8 | 2.83 | 2.84 | 2.92 | 3.01 | 3.19 | 3.3 |
######## | 2.2 | 2.26 | 2.34 | 2.49 | 2.69 | 2.87 | 2.93 | 2.98 | 3.07 | 3.15 | 3.3 | 3.39 |
######## | 2.12 | 2.19 | 2.36 | 2.59 | 2.81 | 2.88 | 2.94 | 3.01 | 3.05 | 3.13 | 3.19 | |
######## | 1.95 | 2.11 | 2.28 | 2.46 | 2.62 | 2.7 | 2.74 | 2.81 | 2.86 | 2.95 | 3.02 | |
######## | 1.94 | 2.03 | 2.21 | 2.44 | 2.67 | 2.77 | 2.85 | 2.92 | 2.96 | 3.03 | 3.08 | |
######## | 1.77 | 1.93 | 2.11 | 2.33 | 2.52 | 2.63 | 2.73 | 2.81 | 2.85 | 2.91 | 2.98 |
<tbody>
</tbody>
Basically, I want two things:
1. To return in successive rows (single column) the dates that correspond to those raw wherein the value in column 5 YR was greater than that in column 7 YR.
2. (related to the previous) To return in a single cell, the count of the number of rows wherein (again) the value in column 5 YR was greater than that in column 7 YR.
I think that the idea it's simple but I cannot get my head around it. I have been trying VLOOKUP, INDEX, MATH, COUNTIF, etc, but I was unsuccessful to date.
Thank you for your help!