Snasui Excel Forum

Hi Dear
I have name and value in column a and b.
i need to transfer value greater than 20 by column wise.
I attached a template with result in color cells

Thanks

...

D2

=IFERROR(INDEX($A$1:$B$20,AGGREGATE(15,6,ROW($B$2:$B$20)/($B$2:$B$20>20),INT(COLUMNS($D$2:E2)/2)),MOD(COLUMNS($D$2:E2),2)+1),"")


Norkaz

Thank you