filter rows

Hello everyone, I am a kind of newbie with pivot tables and this is my first question on this forum. Suppose that I have some data in table and want to create a pivot table on its basis with the ability to filter not just columns, but also rows (motivation is to compare something side by...

Hi, I use a big pivot table with ~10,000 rows of data to make monthly individual reports for my colleagues. It's filtered with colleague name and Location, which indicates type of activity - two filter fields at the top left. Today I tried recording a macro to make the pivot in the hope of...

In Excel 2016 I'm trying to filter on a pivot table to include only the top 20 accounts (coming from a very large cube containing 20,000 + account IDs). I know it is very easy to filter on top 10, by simply clicking on Value Filters and choosing to include only Top 10. I was hoping there may...

Need VBA solution for identifying a specific string in Column E, and deleting all the other rows that don't have that string. FYI - Using MS Access for Remote Automation of an Excel Workbook The code below was designed to open the workbook with a CSV converted file of over 1,000,000 rows (2 to...

Hello! I'm trying to figure out how to show the same row when different criteria are used in the same column. It's a little hard to explain clearly what I'm trying to do so I'll just use an example. Say I have big spreadsheet with thousands of rows that refers to projects that takes place in...

Version: Excel 2010</SPAN> Hi,</SPAN> My challenge is that I need a way to filter the rows of a spreadsheet with the criteria being any cell that contains a certain character sequence.</SPAN> For example:</SPAN> The criteria is: '12345' (without quotes). Rows that contain a cell with...