I have a table. Column A is Activity,
Column B is a list of values that run from BA9 to B108 which are EXPENDITURES, and from B111 to B160 which are INCOMES
I want to take the 5 largest and the 5 smallest numbers from the entire list of Expenditures and Incomes and put them in a separate table on a new tab where column C is the Activity and the value goes into column D if its an Expenditure and column E if its an Income.
TIA
Column B is a list of values that run from BA9 to B108 which are EXPENDITURES, and from B111 to B160 which are INCOMES
I want to take the 5 largest and the 5 smallest numbers from the entire list of Expenditures and Incomes and put them in a separate table on a new tab where column C is the Activity and the value goes into column D if its an Expenditure and column E if its an Income.
TIA