sorting

I have data by month January-June and each week is labeled week 1 through week 26. I want the weeks on the row side and months on columns, but every time I sort it the pivot table does week 1, week 10, week 11, week 2, week 21, week 3, etc... how do I have it go week 1, week 2, week 3, etc?

Hello guys, im setting up a tool and one of the steps is to merge some data together. It's a large document and my initial idea was to cycle back from last row, and check 2 cells, if they match between the 2 rows, a 3rd cell merges both row values and deletes the old one. <tbody> row nr /...

Hi, I have previously been inserting RSS feeds (as an HTML table) into an excel document and running the below code to update the details and sort by the date column in all tables, when the document opened. When finished the document then saved and closed. All was working great until I...

Every third or fourth time I open this workbook I get the error "Removed Records: Sorting from /xl/tables/table2.xml part (Table)" I have no Idea what to do. Any Ideas?

I did a transfer using VBA. I am having trouble now filtering the data and sorting it. I used the following in VBA: Sub Copy() Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("A5") Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("D5") Sheets("Data...

I am doing lottery odds on excel for fun. So I am doing a 5 column lottery. I am trying to figure out in Column I (Labeled 4th Ball) How to highlight the numbers that show up in a row the most frequently and to highlight them a certain color. For example, rows 20-22 all have the number 15 so...

I have multiple sheets with student score data in cells C1:AP9 No headers sort from left to right using row 9. Largest to smallest I tried using a macro with no luck. Any ideas or a VBA??? Thanks

Hi, Is there a way to modify the way Excel sorts cells? This "A to Z" or "Z to A" algorithm is faulty as hell and apparently hasn't been updated since the dawn of time. It constantly sorts words in many languages in a horribly wrong order. Is it possible to create custom sorting routines...

Hi I have two questions. Create filter to find any blanks cells and delete the entire row with it after which show all data Sort in one of the input on Range("E3:E") from A to Z I tried this but keeps getting error "Method of object worksheet error" <code style="box-sizing: inherit...

Hi guys! I am having trouble figuring out how to do the following. Basically, I have a spreadsheet that I need to add controls to so the end user can re-sort the log based on how they want to see the data. Rows 1:6 are headers Print Range is A7:AG1525, but range will grow as new rows are...

I created a pivot table that has name, month, then date in the columns field. The dates values are not sorting in chronological order. I made sure the raw data for the date values are not text and are in date formatting. The end goal is to quickly see by month employees actual sales and if...

Hello, I am looking to have two sorting done with my code. First order is from Custom List and the 2nd order is Smallest to Largest. Here is my code: Dim sStatus As Range Dim sVarValue As Range Application.AddCustomList ListArray:=Array("0 Count","Shortage","Overage") Set sStatus =...

Hi, I am a beginner at excel. A number of months ago I created an excel file, used for sorting quantity data. The first sheet is used for importing (pasting) the raw data. This raw data is then sorted into other sheets depending on the "Product Type" column. I have since introduced two new...

Morning all, One of my colleagues has come to me with a huge list, which contains various bill of materials (BOMs), some of which are identical, but all of which are uniquely labelled. We can't change the software that they're using, so we have to adjust the output afterwards. I've uploaded...

A simple sort routine is being used across a number of reports, but there's a few instances where the sort begins on the second row (row 13) and the not the first (row 12). It's strange, because the same code works fine in the majority of cases. Any ideas? Thanks in advance...

I AM TRYING TO ADD COLUMN “F” TO MY SPREADSHEET TO RECORD “BEST”RANK (COLUMN A) ACHIEVED AFTER SORTING. I SORT COLUMNS C-E, SORT BY MONEY, HIGHESTTO SMALLEST AS THE AMOUNT IN COLUMN D CHANGES. <colgroup><col><col><col><col><col><col span="2"></colgroup><tbody> A B C D E F 1 THIS WEEK +/-...

just looking to sort column D in ascending order, but I need all the columns to sort as well. When I use this code, its just sorting column d and the rest of the columns are mixed up and my data is now incorrect. I do have a header in row 2 that I don't want included in the sort. I just want...

I can't seem to sort the excel datasheet in the right way. It needs to be in a particular way so the products can be merged while uploading. In the screenshot, I show you how it is now and how it needs to be. There are around 65k rows, sorting one by one isn't an option. I also provide a sample...

I want to create the ranking based on 3 columns without sorting method. How can I make this in excel? I saw people using rank and sumproduct, but can you teach me? https://imgur.com/kG5eVlF

I have two fields I need to use for sorting a spreadsheet. One field ("B11") is a date field, the other("F11") is a UniqueID that is partially masked; i.e., "xxxx-xx-0001". I do not believe that my code is sorting ... Upon researching the issue, I believe the data source already sorts the...