Hi there, I've had a problem where I have a row of percentages and I need to find the second occurrence of a percentage that is under 40%. E.g. if I have two rows like this
<tbody>
</tbody>
Then I would like it to return April. I have found lots of ways for finding a second occurrence for rows but not for columns.
Bonus question: I was also wondering if anyone smarter than me could work out a good way to find out if there was an instance of three months in a row where the percentage was 40% above the instance of the percentage you have found previously that is found below 40%.
e.g. with the example above if you find the 2nd instance of a percentage that is below 40% which would be April (23%) then it would search down the row for an instance where there were three percentages in a row that were at least 63% or above.
Thanks so much!
Joe
Jan | Feb | March | April | May |
56% | 44% | 39% | 25% | 99% |
<tbody>
</tbody>
Then I would like it to return April. I have found lots of ways for finding a second occurrence for rows but not for columns.
Bonus question: I was also wondering if anyone smarter than me could work out a good way to find out if there was an instance of three months in a row where the percentage was 40% above the instance of the percentage you have found previously that is found below 40%.
e.g. with the example above if you find the 2nd instance of a percentage that is below 40% which would be April (23%) then it would search down the row for an instance where there were three percentages in a row that were at least 63% or above.
Thanks so much!
Joe