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: 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 ... for...
Memorize constants in Excel ShowMemorize constants in Excel You have created your table, and there are several constants used several times (VAT ,per hour, etc. ..). Solution 1[Basic]: you write them in your forms, ex: = C3 * 1196 to calculate a TTC value from an...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply
They need your help