Shuffle Right
OOp's Meant Shuffle Right
Hi Need Brains
I been trying with formulas but ? ahhh!
Could some master help either using formulas or code to shuffle numbers over in alighnment with right most column of the 6 columns 25 x 6 is all, small region
Thanks alot if you can
Cheers
Last edited by keen2xl; 10-14-2013 at 11:31 PM.
In J3 Cell
=IF(AND(COLUMNS($J3:J3)>(COLUMNS($C3:$H3)-SUMPRODUCT(1*($C3:$H3<>""))),COLUMNS($J3:J3)<=COLUMNS($C3:$H3)),INDEX($C3:$H3,,SUMPRODUCT(1*($I3:I3<>""))+1),"")
Drag it down and right…
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Legend Brother
Perfect.
Very happy man now
Cheers
Glad it helps you and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks