Custom Sorting With Sub Headings
Aug 6, 2014
I've got a few worksheets that have staff names on Col A. And these names are under sub headings of what position they work in (Foremen, Operatives etc..).
Before I had access to them, the names were not in order, now I've change it to A-Z, for each staff under their position.
I know you can make your own custom order list, so the list goes top to bottom : Supervisor, Formen, Operative, Office.
What I sometimes need to do is sort Col B or C. But is am unable to sort it back to it's original state
Attached is an example of how I would like my spreadsheets to look. But is there a way to use Sort & Filter so it sorts the entire table by position, keeping the correct name under the correct position heading.
New Microsoft Excel Worksheet (2).xlsx
View 9 Replies
ADVERTISEMENT
Aug 30, 2013
I have hundreds of rows of data which I need to sort into headings in a new tab.
E.g Column D has about 40 names which occur many times. Column G has 4 digit numbers which are unique.
I want to create in a new tab a column for each of these 40 names, using that name as the heading and then list the 4 digit numbers unders that heading. So if the name name "John" appears 20 times in Column D, it will get a heading in the new sheet and there will be 20 unique numbers listed below it from the data in Column G.
View 3 Replies
View Related
Sep 10, 2013
I know Excel is supposed to guess if there is a heading row or not when you're manually sorting a group of columns. But, more often than not it seems, it guesses incorrectly, forcing me to go through the multiple steps of the "Custom Sort" menu. Most of the manual sorting I do does have a Header row.
Is there a default setting somewhere to force the sort to always assume there is a Header row? I can't find any.
View 2 Replies
View Related
Jan 11, 2010
I am trying to create a custom sorting in VB. My sorting needs to be first on column B, then C and last on G. My data does not have headers.
View 5 Replies
View Related
Jun 20, 2013
In Column A there are randomly assigned numbers using the RANDBETWEEN function.
In Column B there are three possible values X, Y, and Z.
I want to create a sort order where "X" is always at the top but then the rest of the rows are randomly sorted by column A (Y and Z values are intermixed).
Currently I tried to use a Custom List and the value is "X" to sort first, and then a seconday sort of Column A. The problem is that column B is always sorted by X then Y then Z where I am trying to get the Y and Z values to be randomly intermixed based on the sort of the random numbers in Column A.
I know I can manually do 2 seperate sorts each time, but I would like to save a sort list to the file so I recreate that sort over and over again.
View 3 Replies
View Related
Mar 21, 2007
I am trying to create a custom button in Excel that will sort on two different columns. One column has $ Sales and the other has Unit Sales. So you can click on the button and it will sort by $ Sales and if you click the same button again it would sort by the unit sales. I'd also like the text on the button to reflect what option the data would be currently sorted by. I am able to do one of these macros and assign it to the button, but can't figure out how to get both sort options assigned to the same button. I have had outside people send spreadsheets to me with this but can't figure out how they did it.
View 2 Replies
View Related
Jun 20, 2013
I want to sort all of the "column2" by alphabetical order. The order will be first by state and then by city. For example the first box the column2 order should be (Fountain Hills, AZ) properties first followed by (Mesa, AZ) properties second followed by (Peoria, AZ) etc.... ending with (Flower Mound, TX) last.
The issue that I'm having is that when I create a custom sort the comma after the city indicates a new value being AZ. For example my custom sorting looks like this: Fountain Hills, AZ, Mesa, AZ, Peoria, AZ. This is limiting my ability to sort the files as is with city, state. I solved this issue by removing the commas after all the cities. This worked but was time consuming. Is there a faster way? The workbook is below.
Development Projects Mr Excel.xlsx
View 2 Replies
View Related
Jul 17, 2009
I need to custom sort a column. I have 3 different types of data in the column. First - multiple dates, Second - "TBA", and Third - "ASAP". What I need is when the column is sorted the "ASAP" rows will be first, the dates (sorted) will be next and finally the "TBA"s. I have been trying to use a custom list.
View 2 Replies
View Related
Jan 17, 2008
I need to sort numbers in a specific ascending way in excel but I'm not sure how to create a filter, number format or custom sort which will do it.
Sample Data:
245.1
245.10
245.11
245.12
245.2
245.3
245.4
245.13
245.14
245.15
245.19
.................
Sort Result:
245.1
245.10
245.11
245.12
245.13
245.14
245.15
245.16
245.17
245.18
245.19
245.2
245.3
245.4
245.5
245.6
245.7
245.8
245.9
Expected Sort result:
245.1
245.2
245.3
245.4
245.5
245.6
245.7
245.8
245.9
245.10
245.11
245.12
245.13
245.14
245.15
245.16
245.17
245.18
245.19
View 9 Replies
View Related
Jan 28, 2014
Problem we are having with sorting a table.
The table (A1:E10) was created by pulling data from another worksheet using INDEX and ARRAY formulas.
We inserted 6 columns to move the table over to G1:K10 (used column F to space the two tables).
We then duplicated the table: cell A1=G1, B1=H1, ...., E1=K1 and dragged the formulas down. We now have a duplicate table that we want to sort.
We choose CUSTOM SORT and choose 2 levels of sorting ... column A and column C.
PROBLEM: The ARRAY formulation evidently overrides the sort function because the table remains as it was when the sorting command is executed.
Is there a way to bring the data from table G1:K10 over to table A1:E10 in a manner that will allow sorting??
View 9 Replies
View Related
Feb 15, 2014
I'm trying to make a converter between about 8 various types of values. These are not units like Km or miles or something like that, but rather numbers that represent a specific "hardness value" on a variety of scales (to name a few: HRC, HRA, K)
What I've been doing so far is plotting the two types against eachother and then getting the best trendline I can so that I can use that formula to convert between the two with relative certainty. (for example, when plotting HV vs HRC my fourth order polynomial trendline with an Rsquared of 1 is y=0.0001x4 - 0.0188x3 + 1.0768x2 - 20.709x + 350.69)
My questions comes up where I was hoping to make a window or box of some sort allowing the user to input a numeric value, then selecting the Input units and the hopeful output calculated units, and have the box spit back to the user the conversion.
View 9 Replies
View Related
Sep 2, 2008
I want to be able to create a range of VBA userforms to quickly perform long tedious tasks. I want these userforms to be accessed from a nice tidy toolbar.
I have done this and it looks nice and works well. What I would like to be able to do is have my custom toolbar of userform controlled functions be transferable so that if someone else wants my toolbar and attached functions they can install it easily much the same way you can do with an add in.
Is this sort of thing possible or does it require them to manually install all my userforms, modules and toolbar? If it is possible what sort of things should I be looking at?
View 9 Replies
View Related
Oct 5, 2009
I need a vba code which inserts a text/heading into an excel chart.
Today I wrote the heading inside the code, in this way:
View 8 Replies
View Related
Feb 8, 2010
Is there a way to hide the formula bar and headings for a specific worksheet(s) with a workbook but not all the worksheets? In other words, I want to hide the formula bar and headings only for certain worksheets. When I select hide on the show/hide ribbon, it hides it for all the worksheets within a workbook.
Also, is there a VBA code that can be written to hide formula bar and headings for a selected worksheet?
View 9 Replies
View Related
Nov 23, 2006
I have a workbook. Numbers On The Left And Letters At The Top of all sheets cannot be seen. How can I make them visible?
View 2 Replies
View Related
May 10, 2007
I use currentRegion to add the item to the combobox, but i don't know how to add without including the first cell in the range,as usually, it is the field name.
View 5 Replies
View Related
May 24, 2007
I use a macro to format a debtors ledger. This report shows the amounts that customers owe broken down by the age of the debt, ie Current, 30, 60, 90, 120 days.
To make it easier to read I want macro code that will replace these mostly numeric headings with months ie April, March, February, January, December.
View 13 Replies
View Related
Jun 16, 2009
I want to save a worksheet as a CSV but Excel saves the column headings as the first line of the saved csv file. I don't want the column headings in the saved file.
View 3 Replies
View Related
Nov 20, 2009
My questions is how to "freeze pane" a row of headings on the Results page and post the results onto row 2 and downward *without* deleted row 1.
If you look at the attached file, you will see a tab that I created called "My desired Results Page" that simply has a frozen row of cells. Instead of just displaying the rows from the Details page on the Results page, I'd like them there but with the headings at the top.
Is there code that can do this?
View 5 Replies
View Related
Oct 11, 2007
I have data sent to me describing angles as integers from -180 to 180. I need to average these angles together. For example, the average of 10 and -2 should be 4. Great. However, the average of 175 and -175 should be 180.
Has anyone ever worked with this type of issue?
(I've thought about converting -175 to 185, but then I have trouble with 5 and -5, which becomes 355).
I should probably note that I have a list of angles, not just 2. The analysis I need to do is 1) average of all angles and 2) difference from the average for each angle.
View 9 Replies
View Related
Nov 14, 2006
I am trying to find out if i can reference to a table on Excel. For example; if i enter in one cell the word 'january' (a header on the left of the table) and 'week 1' (a header on the top of the table) in another cell, can i set it to produce the value in the table that coresponds to the two headers.
View 2 Replies
View Related
Nov 22, 2006
Assuming I have a data martix which is X* Y. I want to store a range that is at Row Z. I have named a single cell at Row Z as "dataStart". How can I store that Row without the header?
View 5 Replies
View Related
Feb 10, 2007
as you know at the top of the excel 2002 worksheet there are headings:
A B C D E etc etc
how do i change these (A,B,C,D,E) to my own personal heading?
example:
A = Title B = Type C = Subs etc etc
or do i have to 'drop' all the info down by 1 level?
i really need to keep the 'numbers' for the colums so that the 1st entry doesn't start at A2
View 2 Replies
View Related
Jun 21, 2007
TAKING A BIT FURTHER THE POST Find Min Value In Multiple Columns And Match The Header
Here's my problem: I am trying to find the MIN value in a column with dual headings and match the corresponding product which makes my formula with three criteria.
see the attachment to see the structure of the tables and further explanation.
View 4 Replies
View Related
Jul 18, 2007
how do i go about coding a macro so that it can look at a column,lets say column F in this case, on a worksheet and figure out how many rows contain data, select all rows BUT the header row (row 1 in this case), select them for copy, and paste them to another spreadsheet in the xls file starting from row 2, pasting values only.
the way i would LIKE to do this function is to take column 1, determine its length, or how many rows contain data and where the first empty row kicks in, anchor that into a variable and use that variable to set the copy paste function for the remaining columns i run the function on. why do i need this done? i'm makign a macro that can automatically build reports for me from raw data dumpted from the system.... and later columns in the spreadsheet have empty cells, so i want the function to process at a fixed length with all cells using column one as a guide for the copy/paste function
View 4 Replies
View Related
Jun 19, 2014
I have an excel file with multiple sites and I need to delete empty rows base on two repeated words in column A. Empty Rows need to be deleted between the cells in column A called Litter and Community. There are other empty rows that need to stay in so only rows between "litter" followed by "community".
View 3 Replies
View Related
Apr 2, 2014
See the attached excel workbook:
SAMPLE_PivotTable.xlsm
View 2 Replies
View Related
Apr 5, 2009
The first five columns of my table contain row titles. I'd like to keep these columns stationary while I scroll horizontally through the remainder of the columns.
As it is now, only the row number remains stationary, but I really don't need the numbers, just the row titles.
Is there any way to do this? And would this also be possible with column headings (so I can scroll down without them moving up)?
View 2 Replies
View Related
Nov 10, 2013
I want to put in the column headings "listbox" exactly as it is in the sheet, but non-contiguous columns
View 3 Replies
View Related
Aug 5, 2014
Having trouble consolidating 3 worksheets into one worksheet, on these 3 worksheets they all have the same headings which go from A-R. I simply need to be able to run a formula or use some sort of method to incorporate all 3 lists into 1 master list. The only way i currently can do this is to create a vba script which simply copies say 500 rows from the first worksheet paste onto master spreadsheet then copy 500 rows in second worksheet and find next blank row and paste etc.
Is that the best way to do this or is there a better way?
View 1 Replies
View Related