I am trying to sort a column so it'd be like a schedule the earliest time on top and latest on the bottom. I understand it is a form of custom listing but I am not quite sure what is the way to enter that list entry...attached is my excel spreadsheet I am currently working on.
View 7 RepliesI have three columns of data I need to continually order in the same order. DIMM High, DIMM Low, CPU High, CPU Low, Freq High. The second column has the dates these were run and the column after that has the time run. The first column must list the tests in the same order, even if one tests was run twice, so say CPU High was run twice before the other tests were run, I still need the test column to list the other four test and then run the Dimm High again.
DIMM_High1/22/2007 14:52:55
DIMM_Low 1/22/2007 15:54:12
CPU_High 1/22/2007 16:36:43
CPU_High 1/22/2007 16:37:00
CPU_Low 1/22/2007 18:05:48
CPU_Low 1/22/2007 23:05:48
FREQ_High 1/22/2007 22:55:51
FREQ_High 1/22/2007 16:55:51
The problem is, Excel wants to list them by their name first. How can I get the list to appear as below:
DIMM_High1/22/2007 14:52:55
DIMM_Low 1/22/2007 15:54:12
CPU_High 1/22/2007 16:36:43
CPU_Low 1/22/2007 18:05:48
FREQ_High 1/22/2007 16:55:51
CPU_High 1/22/2007 16:37:00
CPU_Low 1/22/2007 18:15:48
FREQ_High 1/22/2007 16:59:51
I am trying to find a way to sort this info by column D but within the Groups shown. So, I want to sort rows 5 to 13, then rows 15 to 19 and then rows 21 to 29.
However I need to a macro to do this because the figures are updated weekly and the order will change. Furthermore, there could be new depts added when the figures are updated, so the row numbers may also change....
I am trying to do an analysis on 4 spreadsheets, each with approximately 4500 cells.
Each vertical cell represents a patient visit to a hospital. There is a timestamp, then a bunch of other metrics that I will be comparing. I want to sort the 4500 visits by time and date. This is how the timestamp of their arrival shows up:
Jul 02 2012 10:25 AM
^A single cell contains both the date and time next to each other.
I want to first separate all visits by time of day. I want to make one group that checked in between 10a and 10p and another for 10p-10a. Then I want to sort both groups in chronological order by date (i.e. starting with 2011 and ending in May 2013).
For one, I'm thrown off because the time and date are next to each other in the same cell.
I'm using the excel built in function to sort columns with my macro. However since my columns have 64,000 entries it takes a while for the computer to sort it.
View 14 Replies View RelatedBasically i have 2 tables like the ones below:
Name Rd1Rd2Rd3Rd4Rd5
Zac 8
James 6
John 8
Frank 4
Name Total
Zac
James
John
Frank
Now i want the total column in the second table to update and add the numbers as i update the rounds in the first one Which i can do through SUM or SUBTOTAL. However i want to sort the total column so the highest number is at the top and everytime i do it changes the name column not the total column.
I have a column which represents by each cell value's number the priority of each row in the table.
What I need to do is create an embedded code that updates the numbers in that column when any value in that column is changed.
For example:
Where the cell values in the column are..
1
2
3
4
5
6
and we change the fifth cell's value to 2
1
2
3
4
2
6
now there are two cells in the column with the same value, we want to keep the value we just changed in the 5th cell but update every other cell that is following the value of 2....
1
3
4
5
2
6
then I would like to resort the table by these new priorities.
similarly if the change is to increase rather than decrease the priority value...where the 3rd cell was increased from 3 ...
1
2
3
4
5
6
changed to 5..
1
2
5
4
5
6
the new change would become...
1
2
5
3
4
6
in this case the 4 becomes 3 and the previous 5 becomes 4 which keeps their relative place in the priority ranking.
I would like this to then resort the table based on this column.
I would like this to execute on the exit of the cell when a cell in the column is changed.
I would like to use the value displayed in column H under the column header after filters have been applied. There will always only be one row displayed after filtering. I'm using Win Xp with Office 2003 ....
View 9 Replies View RelatedI am looking for a macros VBA where a user insert or update a data the date and time should be insert in column I and save the workbook.
Note: If the column I already have the date and time inserted before then it should give message record already have date and time.
I am using office 2010.
I need to sort information in a column containing both numbers and words. In the "asending" & "desending" it only gives two options to choose from. (none) & PartNum.
View 14 Replies View RelatedI have some numbers in a column which due to other cells not yet being filled in are returning a supressed #div/0! error. This is fine, but when i go to sort the column it puts them in the wrong order. I would like to record a macro, and assign it to the column header in order to sort the column.
View 5 Replies View RelatedThis is a simple question but I have been playing around with the syntax(unsuccesssfully) for a while. I want to do is sort a column (not the whole sheet). the column selection being determined by the activecell. I know I can use
View 5 Replies View RelatedI'm trying to merge two or more tables.
The first column of each table is the same field, for example 'Country'. Lets say the first table has information on male population, the second table has information on female population. So i want to merge the tables into one, but here's the problem: table1 has 100 rows (countries), table2 has 96 rows (countries). I need excel to recognise the 4 missing rows of data in table2 and insert blank rows so all the data in table2 corresponds to the correct country in table1 (column1).
Here's a (very) simple example: ...
I have a list of dates in a column that I need to sort. Dates in columns are as follows for example:
02/15/2010
05/02/2009
06/11/2033
04/05/2044
When I get do a sort I get the following result (it appears to be sorting by month, day, year)
02/15/2010
04/05/2044
05/02/2009
06/11/2033
I want to sort by year, month, day. Desired result as follows:
05/02/2009
02/15/2010
06/11/2033
04/05/2044
I currently have a macro that will sort a given column from A1:A5000. The data set can change from A5000 to A6000 or more. How do I edit VBE to accomodate this?
View 6 Replies View RelatedI am trying to sort a range of data by 1 column (column D), and get the following error:
"The sort reference is not valid. Make sure that its within the data you want to sort, and the first Sort By box isnt the same or blank."
Having googled and also checking some previous posts, I thought the issue may be around qualifying my key to ensure that I used the active sheet, but having done this, I still get the error.
CodeRange("A2:V2", Selection.End(xlDown)).Select
ActiveWorkbook.Worksheets("Overview").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Overview").Sort.SortFields.Add
[Code]....
I have Column A where user inputs data. Whenever a user enters a new value in Column A, I need to copy that data into Column B and then sort the whole column. Any suggestions on how to do this using a macro?
View 9 Replies View Related[data]...
now this is the data i have(theres more but this is just an example), i want to sort it with refrence to 'inv' column such that i hav ....
i am trying to produce a simple work sheet that will sort the positions via one column automaticly with out having to do it manually.
View 2 Replies View Relatedi am looking for formula in my macbook pro excel where i have purchase apple 50kg for $50 and grapes 20 kg for $30 and orange 10kg for $15 and am doing this daily and in end of month i want to see separate kg's and amount for whole month and later year of apple, grapes and orange without sorting it
View 1 Replies View RelatedI've question in sorting: I've 2 column in one datasheet. one contain value of numbers and the other contain names of employes. i want to sort the name of the emplyes by the values that is on the first column.
Anther question is how to make it dynamically so ill not sorting it every time that the values of the first column is changing.
I have Danish Office 2007.
1) Let's say I have 3 columns (horisontal) and many rows (vertical. Each row goes together, as the first column can be text that describes a transaction. The second column will be the amount of money and the third can be something else.
I know how to sort these by whichever column I want to. But the problem is every cell needs to be the same size. And I have merged 3 cells in the first column and only merged 2 cells in the last two colums.
So Excel tells me I cannot merge unless each cell is the same size.
Is there a solution here? I need the 3 cells in the first column, so I have enough room to describe the transaction. And to avoid wasting space, I need to only have the other two columns be the size of two merged cells each.
Example, though with the text in another column:
Picture of it
2) The other problem is that I would like a cell to display the number in red if below zero, green if above zero. I cannot do this. I know where to put in the format codes, but I don't know what to write.
At the same time, I need the cell to show the currency in Danish Kroner. So I need a format code that does this. Someone told me this:
[Blue]dk #.##0;[Red]dk #.##0;[Green]*dk #.##0
But that doesn't work, nor if the color is in danish. What do I do?
i have a data of empl their birthdate wise. i want it to sorting from birth day wise for example first " DAY then Month then year". day come first then month then year. find attched file.
View 3 Replies View RelatedI have a column that has something like:
7
5
3
6
4
9
3
11
(continues)
How do I make it to be the order of bigger number to smaller number?
I tried Data > sort Z-A, but then some of the numbers disappear and become "--"
On the attached worksheet, our guys are regularly inspected for performance. Column 'H' shows the average of their grading from each inspection (shown in cols L,P,T etc) What I would like to develop is either a macro button that when pressed sorts them all into order according to their average score in Col H, with the highest score at the top, or to have the sheet do this automatically as the data is entered. Obviously all of the data in the engineers row (all of his inspection history) will need to move up and down accordingly, but not get left behind, or mixed up with someone else's records.
View 4 Replies View RelatedI used the macros found at http://www.contextures.com/xlSort02.html to sort columns. This solution works fine, the invisible rectangle is really good to my interests. Here's how it works: macro #1 creates invisible rectangles at the top of the columns used, at row 1 where the headers are, and assigns a second macro to the rectangles. This second macro sorts the data table based on the column whose rectangle is clicked. The problem is that this solution is for data tables, it sorts the entire table and I want to sort the one, single and only column where I click the invisible rectangle.
View 2 Replies View RelatedSo Column 1 I've got dates, need to sort through that and calculate Year-to-date and Month-to-Date values. These are both Sums of the cells....
YTD = Sum of all cells with most recent yr, in this case 2007
MTD = Sum of all cells in Column B for most recent month, Feb2007 here.
I've listed the desired solution for YTD and MTD on the sheet as well. (I'm guessing the solution will have something to do with SUMPRODUCT?)
I want to sort columns A,C:P and use column C as the column that I sort and the other rows will move with column C. I want column B to stay and not move with the sort. How can I do this.
View 2 Replies View RelatedI need a macro or some idea on how to sort the following numbers (I hope this makes sense!)... The problem is with the zeros get sorted to the top (or even if I have blank cells sorted to the bottom) and I need them to ignore the zeros and sort according to the value in their column but not any other column. However, I need them to be sorted in order from D, C, B, A.
A B C D
0000
4000
101000
0540
0050
6660
ie I need them in the following order.
A B C D
0000
4000
0540
0050
6660
101000
Therefore they need to sort based on the following columns.
This is because I am charting the values in a column clustered chart that need to be in ascending order.
In the attached workbook, sorting the dates in column M results in absolutely nothing happening. The dates are formatted as dates (dd/mm/yyyy). The dates in column M are arrived at by adding a number of days (formatted as Number) to another date, the value of which was determined by an array formula. When I retype the actual date into another column and sort that, I get it sorted. Why does the other sort not work? BTW - I actually need to sort column M with column N.
View 2 Replies View Related