Remember Me?

#1
December 5th 17, 10:54 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 75
Sort Rows Left To Right

The only way that I know how to sort data (left to right) for each
individual row is to use these formulas:

=SMALL(\$B2:\$D2,1)
=SMALL(\$B2:\$D2,2)
=SMALL(\$B2:\$D2,3)

Where B22 is the location of the data to sort. And then I would copy
these formulas down for each row of data in my spreadsheet.

This works well if the data is located in a few columns like the
example above. But the formula is a pain to use if there are many,
many columns of data for each row.

Is there a more practical way that I can sort each individual row of
data left to right?

--
tb

#2
January 1st 18, 07:24 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2018 Posts: 1
Sort Rows Left To Right

ex)

=SMALL(range,COLUMNS(\$A\$1:A1))

and Copy to the right.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Shevvie Excel Worksheet Functions 0 June 24th 08 02:47 PM Carlton A. Barlow Excel Discussion (Misc queries) 14 December 3rd 07 04:41 AM Ben Dummar Excel Worksheet Functions 0 April 4th 07 05:56 PM apprentice idiot Excel Worksheet Functions 11 November 25th 06 01:12 PM David Excel Discussion (Misc queries) 1 February 3rd 05 03:18 PM

All times are GMT +1. The time now is 09:37 PM.