This is my formula which works!
{=IFERROR(INDEX('3.PASTE PARAGON 2'!$B$2:$E$346,SMALL(IF('3.PASTE PARAGON 2'!$B$2:$E$346=$C2,ROW('3.PASTE PARAGON 2'!$B$2:$E$346)-1),COLUMNS($K2:K2)),4),"")}
It basically changes data from a column to a row in a new sheet.
Data changes every day so this is updated in the sheet '3.PASTE PARAGON 2' my problem is the data in this sheet can go beyond row 346 - I want it to capture the whole sheet but when I change the B2:E346 to B:E the formula stops working.
I am currently pulling it apart to try and figure out where I have gone wrong and wondered if it was something simple I am not seeing?
Any help gratefully appreciated.
Sara
{=IFERROR(INDEX('3.PASTE PARAGON 2'!$B$2:$E$346,SMALL(IF('3.PASTE PARAGON 2'!$B$2:$E$346=$C2,ROW('3.PASTE PARAGON 2'!$B$2:$E$346)-1),COLUMNS($K2:K2)),4),"")}
It basically changes data from a column to a row in a new sheet.
Data changes every day so this is updated in the sheet '3.PASTE PARAGON 2' my problem is the data in this sheet can go beyond row 346 - I want it to capture the whole sheet but when I change the B2:E346 to B:E the formula stops working.
I am currently pulling it apart to try and figure out where I have gone wrong and wondered if it was something simple I am not seeing?
Any help gratefully appreciated.
Sara