Hello! I want to use INDEX MATCH using Table 1 to create Table 2 that displays only "Winter" and sorts the month alphabetically. I used the following formula which did a great job of sorting by month, but I can't figure out how to get it to select only "Winter".
=INDEX(Month,MATCH(ROWS($C$2:C2),COUNTIF(Month,"<="&Month),0))
Thanks in advance for looking at my post!
Table 1
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
=INDEX(Month,MATCH(ROWS($C$2:C2),COUNTIF(Month,"<="&Month),0))
Thanks in advance for looking at my post!
Table 1
Rank | ID | Month | Season |
1 | 123 | January | Winter |
2 | 234 | February | Winter |
3 | 345 | August | Summer |
1 | 456 | April | Spring |
2 | 567 | May | Spring |
3 | 678 | June | Spring |
3 | 102 | September | Fall |
1 | 789 | July | Summer |
2 | 901 | March | Winter |
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
Table 2 Month | Season |
February | Winter |
January | Winter |
March | Winter |
<colgroup><col><col></colgroup><tbody>
</tbody>