sort

Hi, Is there a way to make custom sort work correctly on larger files? I created a custom list but both in VBA and in regular excel it does not work correctly on larger files, while it does work perfectly fine on smaller files. Is this a known issue and is there a way to resolve this? Current...

I have an excel file file about a thousand entries that we number like following (please copy/past this in new sheet) Index Item Number 1 F1 2 F2 3 F3 4 F3.1 5 F3.2 6 F3.3 7 F3.4 8 F3.5 9 F3.6 10 F3.7 11 F3.8 12 F3.9 13 F3.10 14 F3.11 15 F4 16 F5 17 F5.1 18...

I want to know if there is a simple form to sort a table by level. Example: I have this table. The item 0 is like top level , any subsecuense .01 are part of the 00 level and items .02 are part of .01 therefore items "sort order" for 1 are 2 to 23. I would apreciated if anyones knows if it exist.

I have the following code that creates hyperlinks from all pdfs contained in a folder and listed in column N. Sub extractfiles_hyperlink() Dim xFSO As Object Dim xFolder As Object Dim xFile As Object Dim xFiDialog As FileDialog Dim xPath As String Dim i As Integer...

I have a table. Column A is Activity, Column B is a list of values that run from BA9 to B108 which are EXPENDITURES, and from B111 to B160 which are INCOMES I want to take the 5 largest and the 5 smallest numbers from the entire list of Expenditures and Incomes and put them in a separate table...

Hello Wondering if an Excel expert can help. I'm wondering if this might be due to an update but i'm not entirely sure. I have a workbook at work which is used to track absence. There is a master data sheet which is refreshed with a system report every day, so on the absence sheet, all the...

Hi, would like to ask for help on this. I need to sort the table (new column with both new and theoretically repetitive tags added weekly) by match and frequency. Any idea how to do that? Example: first line - tag in row matches, most frequent amongst all columns second line - tag in row...

Hello, I'm trying to sort the date in an excel sheet, I want to click on a button to do this, but button is not at the same sheet I assigned the macro in a button in the same sheet, it worked very well, but when I moved the button to another sheet it's not working! what should I edit in this...

Hi All and hope you are doing well, I have a PDF file that contains 500+ pages containing a unique number on each page. First I wanted to sort them with Acrobat PDF Pro DC Actions/JavaScript but its hard and I don't understand Java at all. I also want to clear here that I get this PDF from...

Hi, I am trying to sort some data, if I indicate header:=xlyes it only exclude the first row. However, I need the first 2 row to be excluded from sorting as I have the first 2 rows as header for my table. Does anyone knows how i can exclude the first 2 row when sorting my data using VBA? if it...

Hi all - I have a table of raw cashflow data which I'm hoping to do an XIRR formula on based on an inputted deal. However the raw cashflow data is not always sorted so that the first cashflow is negative. This causes issues with an XIRR formula Example data in table below. I was hoping to use...

Hello, I have this very simple code Sub SortByTime() ' ' SortByTime Macro ' Sort by Time ' ' Keyboard Shortcut: Ctrl+Shift+M ' Range("C4:J43").Select ActiveWindow.SmallScroll Down:=-36 ActiveWorkbook.Worksheets("Jan_1").Sort.SortFields.Clear...

I formatted row labels (see image below) as number in original table and checked with isnumber. However here in pivot table they behave like text. I want to sort them descending.

Hello, I am a math teacher and many of the online tools that I use allow me to import questions and 4 multiple choice answers from excel. So my goal is to have excel create the right answer and then 3 random unique values (so multiple correct answers don't appear) and put those 4 values (1...

I have a list of suppliers that goes on a rolling basis. I'd like to be able to know which suppliers are next in line based on when they last accepted as it should go the longest waiting and if they are available. Supplier Status Date of Last Accepted Test 1 Available 31/8/22 Test 2...

Hello, I have a Pivot Table that I created showing Year over Year (YOY) changes and I would like to sort this Pivot table to show Negative Values on top. I am showing years 2019,2020,2021, and 2022 and I would like to show the negative(YOY) for each year on top of the table. Is there a way to...

Hi all you wonderful people, I am trying to return a list of distinct items using the sort formula below. =SORT(UNIQUE(FILTER(sheet2!$P$2:$P$300,sheet2!$N$2:$N$300="Test1"))) This works perfectly, except I only want to return items where sheet 2 column N = “Test1” or “test2”. I am guessing...

I'm using the following code to sort a range. ThisWorkbook.Sheets("Area").range("A1:D18").Sort Key1:=range("B2"), Order1:=xlDescending, Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom It works well when I place it in a module, but when I use this code in the...

Hello everyone I want your help. I try to make a VBA macro that this will be able to automatically search for the word TRD in the column and check from column E if the total time is less than 00:03:00 then delete the entire row where the specific TRD is located.

Hello Suppose i have 50 sentences in column A and 47 sentences in column B in Column A in a sentence between words there is space but in column B in a sentence between words there is underscore instead of space but the sentences are very similar and i want to sort Column B according to column...