Search : in
By :

Sorting tables in Excel

metroscout, on Apr 17, 2009 8:54:51 pm BST 
 Report this message to moderators

Hello,
I have created a data table using Excel. I will need to rplicate the base table hundreds of times. I would like to use the data in one cell to sort the tables. The 1st table occupies A3 through 5N. I have lables locked in some cells and vacant cells to the right of these. It is within these vacant cells that I wish to enter data. I am looking to a way to sort the tables, not the cells.

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Sorting tables in Excel » in :
Sorting a table without using the sort function ShowSorting a table without using the sort function Getting started Pseudocode The coding Getting started First of all we initialize a variable $ max with the 1st value of table. Then we will make a loop until the table still contains...
[Excel] Sorting rows only Show[Excel] Sorting rows only Microsoft Excel by default perform a sort on the columns (Data/Sort). To sort the data horizontally, just select the data to be sorted, then Data tab /Sort/ Options/ check the Sort Left to right box in the...
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ......