How do I sort rows keeping columns together?
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.
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?)
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.
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.
Related Applications & Scripts
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.
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.
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)
Resizeable columns (drag&drop column borders of the grid header)
Sortable (click on a header column to sort the grid)
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.
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)
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.