Hi, we have posted this question on the following url but in this there are some change in requirement, we have around 100-200 entry and taking the result in new sheet
only for example we have used the same sheet...
=FILTER('INVENTORY-COMMIT'!A:A,((LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!N1)+(LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!O1)+(LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!P1)*NOT('INVENTORY-COMMIT'!A:A=N2:N3)))
I want remove values from array based on helper columns when filled in. It works when NOT...
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'm trying to use VBA to automate a process I perform multiple times a day. I've figured out a little bit but I've got 2 different columns containing time. The estimated time is sometimes populated so I want to be able to filter on 2 conditions: either ET (Estimated Time) is populated and...
Hello,
i am wondering how to filter words in a data set. e.g men, male without it being part of other words (lament, female etc).
Is there a way of using advanced filter for this rather than a formula?
Thankyou
Hi all,
This should be a simple problem but I seem unable to sort it:
I have a list of numerical and word product codes in B44:B60, e.g HJK/5566712/19
A macro button on each row can copy the data from B44 over to H44 when sent to another department.
Hitting the button again undoes the...
Hi Experts,
I found below code in forums while I was looking for way to use wild card to filter. Currently, it works fine but I want to switch the filtered row to A8 instead of A1.
With my lack of knowledge, I thought I could change .Columns("A:A") to .Columns("A8:A"). But I get debug.. is...
Good day!
Can you please help me with a question on Pivot table Filters?
Taking below as a simple sample. There are (Multiple Items) in the Month ("1987-09" and "1987-10").
Is there any way/formula that I can get the filter set? (to return the values as "1987-09" and "1987-10")
Thank you...
Hi Forum,
This is my first time posting. I am usually able to find my answer to other questions by looking through the forums but I haven't been able to find an answer for this issue I'm having. So I am reaching out to the experts on here. Please and Thank you!
I need to auto populate dates...
Hello!
I have a data where I was success in filtering 2 column which do not include zeros, however, I was not able to retrieve the data which is related to those two columns.
This My Table
Table Slicers on Excel Dashboards
DEPT
Column1
Q1
Q2
BONE & JOINT CENTER
left without being seen...
I'm trying to return the player with the most plate appearances for a specified team and position. The formula in the pic sort of works - it's finding the right value for plate appearances. My issue is I want to return the player's name though.
I could use Index/Match or similar for the example...
HI, we have the following data, and want to filter the data on behalf of the following points. (we have excel 2007 and 2010)
(1) Order Not Received and target date is passed
(2) Order Received but balance Qty difference is 50 or more than 50
ABCDEFGHI1DateOrderP NameTGQtyRecd. DateRecd...
Hello,
I track the whole company's absence on a single excel tracker (excerpt below). At the end of each week, I am required to provide an individual absence report to managers in each location. There are currently 62 in the business across 8 locations and this is hours of work on a Friday.
We...
Hello everyone!
I had this issue in excel on my laptop only and not on PC. I have created a table which is the Master of my workbook. I have used sumproduct, filters, unique function and it was all worked nicely on my PC. But for a sudden when i have move this sheet to my laptop all of the data...
Hi all,
I want to create a button to clear the filter. I have a data in excel that link with SAP. I have 10 column of data.
May I know vba code to clear all the filter when there is filter applied?
As you can see in the picture below, I have filter the project. So whenever I click the clear...
Hi im very new to VBA, my boss has asked me to do something I have very little experience in in a short amount of time :(
I have a large data set exported from a simulation software which looks like this:
5
5
0
-3.34384
45000.55
0.109103
-3.23011
45000.2
0.109103
0.017424
33.0513077...
HI, we have the following data where we have many entry in Sheet1 column A, here we have updated some demo data but we have many entries
Product Code&TS4560&&TS6484&&TS2468&&TS4560& (1)&TS4560& (2)&TS4560& (3)&TS8470&&TS8474&&TS6484& (1)&TS6484& (2)
Want this type of result in sheet 2, where...
Hello all -
In Excel O365, I have a table that has data which starts in row3. (Row 1 and 2 are headers)
In col HJ (starting with HJ3), I have formulas that return "W", "L", or "". (So Win, Loss, or Blank)
In col JS, I have formulas that check if HJ (is a "w". If it is a "w" the formula...
Hi all, I have an interesting issue I have been searching far and wide for a solution to no avail.
I have 3 employees who are assigned tasks every week. They rotate tasks every week. There are about 30 tasks, but they change every week so one week tasks A, J L K need to be assigned and the next...
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 MrExcel.com.
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 "mrexcel.com".
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.