You could also use a dynamic array formula: =LET(rng,A1:D4,clms,COLUMNS(rng),CHOOSECOLS(rng,SEQUENCE(,clms,clms,-1)))
=LET(rng,A1:D4,clms,COLUMNS(rng),CHOOSECOLS(rng,SEQUENCE(,clms,clms,-1)))
Click here for a guide on how to add code tags Click here for a guide on how to mark a thread as solved Click here for a guide on how to upload a file with your post Excel 365, Version 2408, Build 17928.20080
Forum Rules