1. L

    Sorting Apples pt. 3

    Hi, I'm trying to see if its possible to do in excel or to build a macro for the following situation: We have multiple types of apples (Fuji, Red, Gala, Golden, HoneyCrisp, and Green). All apples are each uniquely barcoded that are evenly distributed into 6 baskets. When it comes to uneven...
  2. S

    is there a fast way to match my "cell content" to the "row number"

    is there a fast way to match my "cell content" to the "row number" Hello guys, please help me is there a fast way to match my "cell content" to the "row number"? TT_TT[/URL] Ex: the ones with the yellow Highlight my "cell content" 326 matches with the "row number" 326 my cell content 337...
  3. M

    Sorting Find and Assign specified values

    Item Name Fixed Price Lube Oil Qty1: 549, Qty2:999, Qty 3: 1399, Qty 4: 1699, Qty 5: Dcapsules Balancing Figure of Total Order Value, ABCD1Order...
  4. K

    VBA sort each dataset without removing blank rows

    Hi to all and thanks in advance for the help... I am trying to create a macro which will do the following in my sheet: I want to sort (each time with a column of my choice), each one of the small data sets, which are located between empty lines of a large data set. For example: I want to sort by...
  5. E

    Sort 15min (96) entries per day in single row

    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 =...
  6. T

    UDF to reformat hierarchical numbering for sorting

    The fact that Excel is unable to identify and correctly sort hierarchical numbering (ex. 1.1, 1.2, 1.2.1, 1.2.2, 1.3...) is an age-old problem which has been widely discussed in many fora. There are numerous workarounds, but they are often project-specific or formula-based. At the moment, I have...
  7. M

    Subtotal by Funding on one sheet but put the results on another sheet

    What I'm trying to do is create a macro that does the following: 1. On the "By Transaction" worksheet sort by the Funding column . 2. Subtotal by Total Amount Due by a change of Funding 3. Copy the Funding and Total Amount Due Subtotal onto another sheet "By Funding" where there are other fields...
  8. C

    Pivot table sorting numbers as text

    I have a pivot table created from a table on a different worksheet. My first row is a field called Working Week followed by 2 other fields. I am trying to sort the Working Week columns numerically from lowest to highest but the pivot table sees the data as text and is not sorting as I would...
  9. G

    Using Excel to Sort and display Contest results for different categories

    I am extremely new to any complex workings or Excel. I know how to create a simple spreadsheet and how to manually sort the columns while looking at that spread sheet. I am looking for assistance in how to create a document for contest results. The goal is to be able to enter the data on one...
  10. 0

    Formula Sorting and nested IF statements

    I am working on a project for an event where contestants time is recorded real time and depending on all the other contestants scores (as they are entered) a "place" and a "score" are awarded. 1st, 2nd, 3rd, etc places are awarded points if they are members, based on the contestant with the...
  11. Saher Naji

    Sorting Excel rows

    Hello, I'm trying to make the formula working on each 2 rows respectively, but I couldn't FX SWP product is displayed in 2 rows. I want to separate the two rows, and put one in the Short sheet and one in the Long sheet. Each FX SWP has the same Swap Number, with two Trade Number, one will have...
  12. lockarde

    Sort range based on value

    Good morning all, I have an issue with a spreadsheet I use to track job details. Ideally, these details are supposed to be entered as they come in, but sometimes people wait, and suddenly there are details from several days or even weeks past. Is there a way to sort all of these details by...
  13. V

    Scheduling Sheet

    Anyone able to provide some quick help? I have a worksheet I am working with to schedule fabrication. I need two macros to format the sheet and a background process. Macro 1: Button Labeled "Fab Start"; sorts by Column I "Planned Start" oldest to newest creates...
  14. S

    Command action button

    i need a command action button to sort a table called table1 based on column ”No. Date” from Z to A. it’s important to note that my table increases everyday so the range must not be limited to a certain limit
  15. V

    Sorting Poducts VBA Running Slow

    Hello All, Thanks for the Education you are providing. I have been using the below code (originally created by Hiker95 in here) for the last 4 years now but now it is getting very slow to sort products, This is used to sort products entered randomly for each order with different products...
  16. A

    Sorting Dates with General format and time stamp

    Hello All - I have been sent a worksheet with dates from a user in Australia. The date format is: 17/06/2016, so Day, Month, Year. And to be more specific, what I've been sent is: 17/06/2016 18:53, so D, M, Year and a time stamp. There are other dates that I need to merge and sort with these...
  17. L

    reversing the order of 2 columns

    Hi Is there any way/trick to reverse a table without using sorting? Here is my table From <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> average grade 0 f 50 c 60 b 80 a </tbody> To <colgroup><col width="64" span="2"...
  18. A

    First time creating macros for complicated sorting

    Hey, all! Just a bit of background: I work in sales at a hotel. I've been tasked with manually entering our numbers into a new system until it interfaces with the program the front desk uses to keep track of rooms. It's daunting. I'm given an extremely dense Excel file with information about...
  19. G

    Maintain cell value of referenced cell after sorting

    I have a list of values in range B6:B52; each value represents a report. In column D, I have the name of the reports going down the column referencing column B such that: D6 = B6 D57 = B7 D108 = B8 D159 = B9 .. and so on As I add values to column B, the value automatically gets referred to the...
  20. N

    I am Hoping to Find a Sort Macro

    Hello...I am a schoolteacher who wants to provide students with a chance to retake failed tests, and I want the data organized by class periods. I am requesting a macro to perform the following sort functions: Sort 1 is ascending from A2 to AT205 sorting by Column AT(Test Score) Sort 2 is...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back