sort & filter

I have one excel file that has two tabs that i want to work together. In Tab1 i want the priority list to be updated manually. Then on tab2 i want the priority list to be filled automatically from tab1. The order numbers will be in different sequence on both tabs so i want the priority to...

Hi Experts This is the power of Excel - That you start to believe can I go 1 level further. Recently I had a thread - https://www.mrexcel.com/board/threads/filter-unique-values-out-of-a-multi-column-list.1251328/post-6140661 where @Eric W @ISY @Fluff gave me the solution. Due to my system...

Hi all: Here is my formula: Thanks in advance for any help! =IF(J11=">=", SORT(FILTER(A:F,(F:F>=I2)*(ABS(E:E)>I7)),6,1,FALSE), SORT(FILTER(A:F,(F:F<=I3)*(ABS(E:E)>I7)),6,-1,FALSE)) I want to filter by values in F and Absolute values in E, and then and then sort results...

Hi, I have a market analysis sheet which is shown in the picture. As seen in the picture i have a column "p:p" where i can type in a date for each row. I want to make a code that colors the whole row green if its less than 1 year to the date, yellow if its more than 1 year but less than 2 years...

I am trying to create a formula or something with VBA to help me sort five columns of data. I’ll briefly explain – I use video games to learn languages, and I’m trying to create a multi-subtitle system for Baldur’s Gate 3. The text is organized via Content UIDs (for all languages)...

AB1Group 1Group 22453374365256782 When I sort column A from largest to smallest, it automatically interferes with column B. I tried in different ways, but I couldn't make the filter of column A not interfere with B and vice versa as well. My goal is to sort the names in columns A and B in...

HI, we want to filter data from two column to one as per result sheet (Excel 2007 and Excel 2010) ABC1S.No.BarcSecond2132SQ35143SQ35254SQ35365SQ35476SQ354 - 187SQ35898SQ354109SQ354 - 21110SQ354 - 31211SQ357 Result Sheet A20Final21SQ35122SQ35223SQ35324SQ35425SQ354 - 126SQ354 - 227SQ354 -...

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.

Hi Experts, I have an excel sheet where the data "in Plan" columns are all copied in with a macro from different sheets. I need a way programmatically (ie as part of the same macro) to Sort the columns by Row number 2 - "Ship Date" (left to right). I want the sort to happend At the end of...

I am running a college football pool and I want to get a list of all of the teams that are playing in the games this year. I want to return the names of the teams in column K & M, in one column (separate schedule) if Column C is "2022". Is there a way to use the filter to pull from both...

Hello Excel Experts, I have a dynamic spill array that pumps out values matching various criteria. In my example below, my spilled array returns four values (IDs), and in the next 4 columns I grab additional information with XLOOKUPS based on those values. Is there any way to sort my spill...

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...

Hi, I have a list of sample numbers, each in doubles. I receive them like this: 15243 18764 19370 13749 15243-2 18764-2 19370-2 13749-2 Now with the normal sorting function your corresponding sample are not listed together but rather like this: 13749 15243 18764 19370 13749-2 15243-2 18764-2...

Hey everyone.. first time poster here so i might be missing some useful info you need. Please let me know if you need more info. I have a range of data which i need sorted by date, then copied and pasted into another sheet. The data will continually be added to so it needs to copy from sheet 1...

Please can someone tell me how I can amend this formula so that it returns all numbers in column F up to the last row, i.e. so that I can use it repeatedly on workbooks which have different rows of data. Sheets("Lists").Select Range("A2").Select ActiveCell.Formula2R1C1 = _...

Hello, I'm really new to the developer side of Excel and I wish to solve a problem with macros or VBA. I have a table of items placed in colums (there are around 50 columns). In this table i scan a DMC (data matrix code) and place it in cell that it needs to be in. I'm kinda getting tired of...

Hello, I have an excel workbook with 24 sheets. I have created a macro (see below) which I hoped to use on all 24. Unfortunately it only seems to work 'properly' on the first sheet (the sheet the macro was created on) and not 'properly' on the rest. When I say properly I mean the macro is a...

I am currently working on an excel formula which give me a sorted array of unique items and their values. I have reconciled the steps in the following excel but couldnt crack it to one step. The difficulty is also higher due to the multiplication of two colomns (i.e. asset value & % ownership)...

Hi guys! You've helped me so much in the past, I'm hoping you can help me again. I get a large data dump I have to do once a month but I have some formatting and moving around I need to do. (Lots of sorting, moving, resorting, etc.) I use a vlookup multiple times to pull in data from another...

I was wondering if someone could please help me. I have a sheet with numbers data that I am calculating through various formulas such as sums and ranges and averages and sort functions etc. My problem at the moment is that I have for instance in Column Y a set of numbers that is the main...