Categories
Development

Reverse array list dynamically

I have an array list in column A (starting in A2) using: {=IFERROR(INDEX(MonthSpend,MATCH(0,COUNTIF($A$1,A1,MonthSpend),0)),””}` Where MonthSpend is a named range from a table on a separate sheet. I have copied the formula down to A300, but inserted blanks in a number of rows. From the picture you will see that I have each month showing up […]