Hi,
I'm looking to create a list of returns/ statements from one sheet and then list them on a second sheet.
I have an array formula ( see image ) which lifts statements from a column based on criteria I set ( there are 3 criteria and I've used the array to create 3 lists - but only for the column highlighted ).
I now want, on my other sheet, to be able to choose which column that array formula lifts the statements from and then list these statements linked to the criteria assigned to the array. i.e. I want to be able to show only the statements from Rec Aut or y3 Spr or Y5 Sum etc columns on the 'other' sheet. I know I could create 21 separate sheets to do this and get it to simply copy the lists created by the array but that seems to be a very convoluted way of doing this.
I'm not very good at Excel but I hope I've explained that well enough that someone might be able to give a simple solution.
Many thanks
I'm looking to create a list of returns/ statements from one sheet and then list them on a second sheet.
I have an array formula ( see image ) which lifts statements from a column based on criteria I set ( there are 3 criteria and I've used the array to create 3 lists - but only for the column highlighted ).
I now want, on my other sheet, to be able to choose which column that array formula lifts the statements from and then list these statements linked to the criteria assigned to the array. i.e. I want to be able to show only the statements from Rec Aut or y3 Spr or Y5 Sum etc columns on the 'other' sheet. I know I could create 21 separate sheets to do this and get it to simply copy the lists created by the array but that seems to be a very convoluted way of doing this.
I'm not very good at Excel but I hope I've explained that well enough that someone might be able to give a simple solution.
Many thanks