sort and group

Column A in the Rows of my worksheet either contain a date or are empty. I need a method that would sort the column the lists cells that contain dates and that contain no date.

Good Day, I've had luck in the past so I'll try again and a big thanks to everyone who's helped me before. So, I have worksheet 1 that has data in columns A through M and worksheet 2 with data in columns A through F. I need to be able to match the data by number in worksheet 1 & 2 on column...

I have two columns of times, as below which are derived from formulaes from other sheets <tbody> Time Out T/O 1:00 LG2 3:20 LG1 3:30 LG1 3:30 LG2 5:22 5:31 LP8 5:55 SF2 6:42 SE1 7:50 LP11 8:42 G80 </tbody> but when I alter some times on the other sheets, they...

Hello, & thank you for any help you may offer! I tried to search the forum but could not find an answer to my issue. I have a powerpivot table from my data model with 6 columns, & (currently) 2 filters (wanting to add a 3rd but need to figure out the relationships- different issue). 3 of the...

I have two sheets (costing and recipes) that share the same data in column A (Ingredient)(functions as primary key and always initially entered in the costing sheet). When I add a new Ingredient to the costing sheeting and sort that column it sorts correctly in the costing sheet and all the...

Welcome, I've got data as shown. My role is to sort them / group them under some conditions simultaneously: condition no 1: for one group of 'H1' maximum 'PCS' sum is 25 / for H2 is 9 (condition no2 must be kept) condition no 2: sum of val multiplied by 'PCS' is not greather than 9 for...

The title isn't as clear as I'd like but it's the best I can think of. I have data that I need to sort using multiple fields, and then, put keep in grouped pairs. There is an example below: <tbody> ID Group v1 v2 v3 v4 1 1 1 2 1 2 2 3 1 2 3 1 3 1 1 2 2 3 4 2 1 2 3 1 5 4 1 3 1 2 6...

Hello everyone, I have a tricky question, and it is hard for me to describe the scenario into words. It is better that you see the screenshot first: This is a PivotTable by summing up the values from a PowerQuery; and then the result is presented into rows by each numeric ID (level 2, ex...

Hi all, How do I sort within an outline group? I have a set of data grouped by country, and would like to sort both levels of data by the same column. Using a regular sort function just sorts the country level, and doesn't sort items within. How would I do this without using VBA? Seems like...

hi i have a price list. alot of the entries are duplicate. my main objective is to remove the duplicates. but just removing duplicates with the default function is not what i want. i tried sorting the column in alphabetical order but that doesnt help completely. as there some entries of a single...

Hi, I need to sort a table to be in order of the numbers and letters from column A. They are not in order at the moment. I would like them to look like this: 1 1a 1b 1c 1d 1e 1f... 2 2a 2b 2c 2d 2e... etc Pressing 'Sort A-Z' does not give me this. Any suggestions? TIA

I am trying to find the last number in a range of cells that include both text and numbers - the range is not fixed and will always change. I know that if I sort the range with the text included it will not truly sort the numbers, so realise that I need to separate the text from the numbers...

Hello, I have about 22000 rows of data, and 100s of columns. Auto-filter just takes too much time to filter data, as does a pivot table. I would like to know if there is a way to make a drop down list with some of the data that will then filter or sort the data. My ideal situation will be to...

Hi I am looking for a way to help my Mom's bowling league. She needs to divide the 64 players into a 8 teams of 6 players each. But would like that the total point (total of individual scores in each team) of every team be relatively the same. And to make things even more challenging... 8...

Hello all, I have a table like so called SEASON 1: <tbody> Player Appearances Goals J. Hart 9 0 V. Kompany 9 1 Y. Toure 10 6 E. Dzeko 10 4 S. Aguero 8 9 S. Nasri 9 1 D. Silva 7 2 G. Clichy 9 0 J. Milner 10 0 </tbody> Now I have another table called SEASON 2: <tbody>...

Hello, Newcomer here seeking help. Using MS 2010. My question is lets say my workbook has 2 worksheets (or tabs) Worksheet 1 contains names (and info associated with it )that is unsorted alphabetically, i just log them as it comes in the order of which they came, for example: Name...

I am new to macro. Hope someone can help me in the macro Data: ColA ColB ColC ColD ColE ColF ColG ColH ColI ColJ ColK ColL ColM ColN ColN.....ColIR A1 B1 C1 D1 E1 F1 _____________________H1 I1 J1 K1 L1 M1 A2 B2 C2 D2 E2 F2 _____________________Blank_____________...

Hello! I need help guys, I have the filters at the top but i dont know what to do next. I want to be able to click the filter above the state abbrev column, sort by for example FL (for FLORIDA) and have all of the phone numbers populate on the right that begin with the area code that belongs to...

Hi All, I have a huge set of statistical data which needs to be sorted. This data is spread across multiple sheets. The format of the data is "Name (A-Z) - Type" in column A and its corresponding numerical values in arranged row wise. eg: <tbody> NameA_Type1 10 12 14 NameA_Type2 16 18 20...

I've located the following color sort VBA that sorts worksheets by color and it is working well. I'm trying to modify the code to sort each of the "color grouped" sheets alphabetically. That is, sort by color and then each color group sorted alphabetically. I think I'm in over my head on this...