filtering

=COUNTIFS(SERMCTRACKER!F7:F$99,">=" & B5,SERMCTRACKER!F7:F$99,"<=" & C5) This is my formula, as solved at this thread. https://www.mrexcel.com/forum/excel-questions/1025364-countifs-using-dates-specified-external-cells.html I am hoping that I can add to the formula: How can I add a condtion...

I'm trying to do something like calculate(sum([amt]),[s]<>a||dimension[doc]<>b)). It seems so straight forward, but then maybe I need a fake dimension table for the fact column I'm filtering on. Before I implement a dumb solution like that, I thought I'd ask to see if maybe my syntax is just...

Hi, I have a table with more than 1500 records. When filtering the data it shows data that should not be included in the selection. I went to data+fitering+advanced and made the selection $B$10:$AD$1658. Being those the beginning and the end of the table respectively. What am I missing...

Hello, I have a user form for filtering my desired inputs in all available tables in each sheet. It works perfect for text strings, but I can't do any filtering on the numeral fields! I am wondering what I am doing wrong!:( Thanks for your support. Here is the form image and the code i have...

I'd like an opinion on the best way to do this: I have a worksheet with 60 columns of raw data. I want to be able to take only certain columns from that sheet and display them into worksheet 2. I just used the "=" formula to replicate what was in the first worksheet to the second one on my...

Hi all, I recently started using Excel and have been trying to solve a problem involve sorting and counting. I'm sure it's been encountered many times before, but am having trouble figuring it out. I tried searching for answers on the forums, but was having trouble putting my question into...

Hi guys. Based on the code below. I am trying to filter all the serial numbers in the Cust_Order_num_col that begin with a "35" or a "45" and do not contain a "/" It seems to work except its only filtering for the second item in the array, in this was "45*". The second criteria seems to...

Hi guys. Based on the code below. I am trying to filter all the serial numbers in the Cust_Order_num_col that begin with a "35" or a "45" and do not contain a "/" It seems to work except its only filtering for the second item in the array, in this was "45*". The second criteria seems to...

Hello All! I did a search and couldn't find a post that matched what i'm trying to accomplish. If i have a master team schedule...showing AWAY games in column G, and HOME games in column H, i want to be able to filter and see the teams ENTIRE schedule. right now i am filtering home, then...

Hello, I have a macro that will open my holiday sheet and filter it to anyone who is off today and display me the results (amongst other reports that i run each morning). Currently, it just shows me who is off on that day, i would like to see a list of everyone who is off within that week...

I have a worksheet where the dataset will never be the same from day to day. I'm using filtering and I show only rows that do not equal a #N/A value. I recorded a macro to delete the non-#N/A rows. In this particular example, there are 101 rows to delete. How can I - without arbitrarily...

Hi Everyone, I have several hundred cells that I need sorted. The problem is, if I sort them alphabetically, it is in the wrong order. Here are examples of my data: PC1000-BKS-750lb-MS PC1000-BKS-550lb-MS PC1000-CG-750lb-MS PC1000-CG-550lb-MS PC1000-DC-750lb-MS PC1000-DC-550lb-MS If I sort...

I am looking to use the number entered in a cell as the "greater than or equal to" value filter for my pivot table values "Order History" and "Percent Difference." I only want to see entries where Order History is greater than cell F3 AND the percent difference is greater than cell F4. However...

Hi there, I recently had a problem whereby I couldn't sort my data within my worksheet due to my sheet being protected and also certain cells being password protected. However I have now sorted that issue whereby I have highlighted the cells I need to sort and password protecting it - So when...

Hi there, I am working with a contact list of over 3,000 individuals. I need to remove people from the list who don't have either an address OR email. If they have one or the other, or both they remain on the list. Is this possible? My current method is to use the Ctrl+G option > Go To Special...

I am looking to customize the QUARTILE function to automate the selection of value range satisfying a specific condition. https://drive.google.com/file/d/0B9uhATNT4QB2X1ZjNWlSYTFPMHc/view?usp=sharing https://drive.google.com/file/d/0B9uhATNT4QB2WUktTktsR19wQjA/view?usp=sharing I am able...

Hi there, I currently have a command button and when pressed a userform interface appears. However if a filter is on in the spreadsheet and I press the command button a message box appears stating that "filters are on. please turn off filters before entering information in the userform" - then...

I have a large spreadsheet with about 156k rows, that ive divided into rows of 10k. I only want the duplicate values. So, I've performed conditional formatting, and added a filter. Problem is, when trying to filter by color, excel indexes all values of 10k before allowing the drop down to appear...

Using Excel 2010, I can double click any cell containing data in pivot tables and get all the entries for that particular cell onto a new sheet. For example, if I want to know where the $100 total in a cell comes from, I just double click on the cell and a new worksheet pops up listing all the...

Hello all, I have a worksheet that needs to have autofiltering added to it. The problem is that I do not control the format and there are misc data rows underneath the totals row and Excel picks these up in the _FilterDatabase named range. This value can be seen by clicking the Advanced icon...