sort

How do you keep a row of cells together when the first cell in the row is being sorted by a sort function on a separate Page. currently, when the NY, PA & OH cells are sorted on page 1, the data next to them is mixed.

Hello, I have to sort daily our inventory as per criteria. is there any add-ins in which i can save the order of the sort and use everyday. Thank in Advance.

Hi, I'm looking for a very specific way to sort some values contained in a cell that are separated by spaces. The values all starts with two digits followed by two letters. Some contain more numbers following the letters but they are not important. I'm looking to use a UDF to sort the...

Any help would be tremendously appreciated. I am on hour 2 of trying to figure this out. An example: Tab 1: Job # Job Revenue Job Cost Job Status Job Mat Spend 23 100 80 Closed 20 42 200 150 Active 10 56 100 90 Active 30 71 150 30 Active 40 83 100 85 Active 40 I have around...

Hi, Thanks for looking at this... I have the code below that takes a custom sorted list from a Listbox in a Userform puts the items in to an Array and then creates a custom sort to be applied to a table called 'RotaOutbound'. The code all works fine when I tested it on a list in a column but...

Hello! I have a simple pivot chart collating some totals for figures in each month of the year. I would like this to display in the month order (Jan-Feb) but I am unable to manipulate the source data so it reflects this. Is there another way to do so? I do not have an option to use the custom...

I'm having a bit of trouble with sorting a table using VBA. The macro I'm using is this Private Sub test() Dim lo As ListObject Set lo = HCP_justering.ListObjects(1) lo.AutoFilter.ShowAllData With lo.Sort .SortFields.Clear .SortFields.Add _...

I'm trying to solve a problem, so far without success. I have a pivot table and , with VBA code, I would like the values in the 'Country' field to be in the exact order I specified: (blank), Czech Republic, Finland, Denmark, Norway, Spain, Greece, Brazil, Argentina This is what I have: I...

Hello, This is a data sorting question. Sort 15min (96) entries per day in single row. This way each row has single date with a column for each 15 minute interval of every day instead of 96 rows of the same date end to end and only a single column of data entry. Restated; Currently, Column A =...

Hello, I'm needing help to find a way to filter data without using the updated filter and sortby functions released in excel 365. Is it possible to filter data using multiple criteria with basic excel functions? I've attached a sheet with cell A4 using the filter function to produce the desired...

I am trying to sort a sheet by blanks in 2 columns. For example, any row that has blanks in both key columns will be deleted. However, if either or both columns have information, it should be left alone. I'm struggling to get this to work with both columns rather than just one.

Hi there! Just wondering if someone can point me in the right direction for this, as it's been racking my brain trying to figure this out. Basically, I'm retrieving data from another table using the formula =VLOOKUP([@[Entry Number]], 'sheet3'!$B$2:$M$191,2,FALSE), which is fine working well...

Hi All, I would like to know how to achieve this condition programmatically. The main idea is to collect the same "attribute name" for each row for each grouping (column 2) Note: Grouping will be more than 1. like : Logi1, Logi2, Logi3, etc From this : To be like this (result): I had...

Welcome to another episode of bending Excel to our collective will. I have a workbook that currently contains 45 sheets. The first sheet is just what I use for data validation lists for drop down boxes elsewhere in the workbook. The second sheet is my raw data sheet, containing up to ~25,000...

I have a excel table in the form below: Level1 Level1- Level2 Level2 Level2- Level3 Level3 Level3- Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild records and so on... Level1-Level2 is...

I really thought that this was going to be simple, but I just can't figure it out. I have a list of 70 values in a range. There are multiple rows of values for each of these columns. For this example, the rows could be a physical good, and the rows are customers. The values in the table...

I am not well versed in VBA and have no idea where to start finding the issue here. I need to write a function that will take a 1 dimensional array as an input and spit out a new array with all the values sorted alphabetically and duplicates removed. This input "SourceList" column has text...

Hello, Im new here and i've got a question. I'm making a yearbook for students and i want to check if everyone has filled in the forms enquete. I download a forms sheet with the input from the students and now i want sort the data with my other excel (The excel with al the names) How can i...

Hi All, Can someone help me with below requirement. I have data sheet1 where there is "Month" header is column "I" and "COUNT" header in column "M". Sample data looks like below. Number Name MONTH COUNT 121 Ram February 40 132 Carey February 32 125 Salim February 40 127 Kumar...

NOPQR1DateIDCostSorted...