You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

How do I sort rows keeping columns together?

How do I sort rows keeping columns together?

Price: FREE

I have an excel ws with information divided into columns (Name, address, phone, e-mail, etc.)--how do I alphabetize the names (rows) while still keeping the information about each person together?

Visit publisher's web-site: How do I sort rows keeping columns together?

Category and Tags: ExcelTutorials : : Functions

Related Tutorials

Keeping Rows Together

Free: Yes
Tags: Excel ›

Is there a way to keep rows together in Excel so that when you sort the rows will stay together and so that when there is a page break the rows will stay together on a page? I have a spreadsheet where the first three rows are merged in column A and then are not merged in columns B and on. When I try to sort by Col. A I get a "merged cells have to be identically sized" message.

Sort table while keeping calculated numbers

Free: Yes
Tags: Excel ›

I have created a table in excel, with the following columns:
Column A Date // Column B Person // Column C Used // Column D Remaining
Column D is calculated by Column D-Column C across all rows.
If I now sort the table according to date or person, obviously the value for the automatically calculated column D changes. Is there a way to keep these values as they are before sorting the table (i.e. that the just "switch" position with the rest, but keep their value?)

remove duplicate rows but keeping all columns

Free: Yes
Tags: Excel ›

I have several columns of information (i.e addresses) and one of the columns has duplicate numbers. I want to remove the duplicates rows and retain the other columns. I tried to do the Advanced filter but could specify which column I needed duplicates to be searched.

Scrambling rows of data while keeping some rows grouped to one another

Free: Yes
Tags: Excel ›

I am currently working a project that requires me to scramble data by rows. Here is an image to help with my explanation:
You will see [number][letter] columns (3B, 4A.) are paired with [number] columns directly to the right. So 3B can be subdivided into 3B - 1, 3B -2, and so on. Or, as you can see more fully, 4A can be subdivided from 1 - 8.
What I am trying to do is randomize all the 1A's, 2A's, etc. but also keep them with their respective subdivisions.
So for example: my randomization may end up producing 2A - 2, 4B - 8, 1A - 1, and so on. I am slightly familiar with the rand() function, but it doesn't seem to help me in this case.

how do i sort an excel spreadsheet by column

Free: Yes
Tags: Excel › Functions

I would like to sort an Excel spreadsheet by random columns, keeping the data in the individual rows together, similar to sorting a table in Access. Is this possible in Excel?

Related Applications & Scripts

Sort Tables Columns using JavaScript

Free: No
Tags: JavaScript › Excel Sorting Data

Implementing a table sort, allowing the ability to sort a table by a column, is a common task and the most implemented solution is to send a request to the server for a new page containing the sorted table. Dynamic Table is a javascript table sort tool which uses javascript to allow client side sorting of your data tables.
With Dynamic Table you can make any data table sortable with just one javascript include and one call to an initialization function. After the call the table will can be sorted by clicking on any of the table headers. Because Dynamic Table sorts at the client side it removes unneccessary load on the server and reduces bandwidth usage while at the same time providing near instantaneous response times for the user.
As an added bonus Dynamic Table also allows the user to hide/show the columns they want to see. This can be a real boon in tables with many columns where only a small subset of the data is required.

BookMarks Favourites

Free: No
Tags: PHP › Excel Bookmark Management

This PHP Bookmarks script is a web-based program that allows you to store your bookmarks and display them in many useful ways. This script will sort your bookmarks with usability in mind, keeping often-used bookmarks at your fingertips. It has a bookmark search, private/public bookmarks, nested groups, usage rankings, popularity sorting, and a quick add feature.

Smart Grid, Ajax-based table editing tool

Free: Yes
Tags: Ajax › Excel Table and Datagrids

Smart Grid is an Ajax-based table editing tool. Allows to manage DB tables without reloading web pages. 100% JavaScript that makes it possible to use it with any server-side technology.
--------------
Features:
--------------
100% JavaScript
Cross-browser (works in IE, Mozilla-based browsers such as Firefox, Opera 9+, and Safari 3.0)
Multiple rows selection (you can delete many rows simultaneously)
Paging (navbar to move among pages, change page size)
Tabbed order of cells in rows (you can move between cells pressing Tab)
Skinnable (change skins using API)
Multilingual
Resizeable columns (drag&drop column borders of the grid header)
Sortable (click on a header column to sort the grid)
XML support
Non-editable cells
Dynamic loading (automatical loading data on grid scrolling)
Frozen columns (columns with independent horizontal scrollbar)
Remote files generator (JS script to automatically build Smart Grid remote files corresponding to your table)
Advanced calendar for date cells.

Ultimate XML 3D Thumb Wall Gallery

Free: No
Tags: Flash › Excel Image Display

This is a 3D gallery that can be used as a 3D photo grid, a 3D photo album or a 3D image viewer in the shape of a 3D wall. It can have any number of images and any number of columns and rows (e.g you can have 10 columns and 2 rows). On a thumb click, it will enlarge, and you can also flip it to see a text on the other side (you can see this in the first example) or you can have the title near the photo (like in the second example)

Pointers to Functions

Free: Yes
Tags: C++ › Excel Functions Pointers

Up to this point we have been discussing pointers to data objects. C also permits the declaration of pointers to functions. Pointers to functions have a variety of uses and some of them will be discussed here.
Consider the following real problem. You want to write a function that is capable of sorting virtually any collection of data that can be stored in an array. This might be an array of strings, or integers, or floats, or even structures. The sorting algorithm can be the same for all. For example, it could be a simple bubble sort algorithm, or the more complex shell or quick sort algorithm. Well use a simple bubble sort for demonstration purposes.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing