PDA

View Full Version : [SOLVED] need VBA to arrange the data from left to right smallest to largest, please!



estatefinds
03-12-2016, 12:02 PM
I have NUMERICAL data in columns ABCDE and need the data from left to right read smallest largest, please
See example on attachment,

Thank you!

PAB
03-12-2016, 02:19 PM
Hi estatefinds,

Put the following formulas in the cells quoted and copy them down...

G11 =SMALL($A11:$E11,1)
H11 =SMALL($A11:$E11,2)
I11 =SMALL($A11:$E11,3)
J11 =SMALL($A11:$E11,4)
K11 =SMALL($A11:$E11,5)

I hope this helps!

estatefinds
03-12-2016, 02:59 PM
Wow! that worked Great!!!! Thanks Again I appreciate your help!

PAB
03-13-2016, 08:55 AM
You're welcome, thanks for the feedback.