0
votes
1answer
18 views

Sorting and showing the most repeated row (value)

I have a sheet containing over 200k+ rows with values like this, 10.10.10.10 11.11.11.11 12.12.12.12 10.10.10.10 10.10.10.10 I want to be able to show the most repeated row at the top or extract it ...
0
votes
1answer
78 views

Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...
1
vote
0answers
23 views

Excel: cannot remove advanced filter

I added Data->Sort&Filter->Advanced filter to a cell that allows me to quickly choose a name from a range of names stored in another sheet some time ago. Now I would like to remove the advanced ...
0
votes
2answers
179 views

How do I count different values/characters in a column of cells?

I'm not sure if my description above is accurate. I have a client's full name and address in a single cell e.g.; Mr Smith, 1 High Street, London NW12 1AB I have hundreds of names, address and ...
1
vote
0answers
70 views

excel: how to filter for a specific ID given time constraints on a text field

I have an excel sheet that has a three fields: USER_ID | DATE_CREATED | TAGS Tags applied to the items in the sheet vary quite a bit, and are set up like |tag1 tag2 tag3...| within the field. I ...
0
votes
1answer
7k views

Excel: filter a column by more than two values

I have a worksheet with a column, user_ID, that contains a large number of user IDs I'd like to filter it down to about a dozen IDs, but using Filter -> Custom Filter only allows me to filter by 2 ...
0
votes
1answer
141 views

Pivot table on filtered data

There doesn't be a way in Excel to run a pivot table on an Excel sheet that already has columns filtered. Thus far, I've had to manually copy and paste the sheet into another sheet and then run a ...
0
votes
1answer
134 views

Using the advanced filter in Excel

I have 40 rows in Excel starting with a SerialID in sheet 1. In sheet 2 i have 109 rows which I would like to filter based on sheet 1. Sheet 1 contains records i want to hide from sheet 2.
0
votes
1answer
334 views

In Excel input filter values in cell

Using Excel I am searching for records using Filters>Down Arrow>Text Filters>Contains (refer screenshot), this is very tedious as the seach window disappears after taking the imput and I have to ...
3
votes
3answers
10k views

Excel 2007: Filtering out rows in a table based on a list

I have a large table that looks like this: ID String 1 abcde 2 defgh 3 defgh 4 defgh 5 ijkl 6 ijkl 7 mnop 8 qrst I want to selectivley hide rows ...
1
vote
1answer
125 views

Filtering product name(from products sheet) in order sheet

I have products sheet in excel workbook but when i add new order line in order sheet in same workbook, i want to filter products when i press keys to write product name. Is there any way to show ...
1
vote
3answers
5k views

Does Excel have a row filtering function (more general version of SUMIF/COUNTIF)

SUMIF and COUNTIF functions are handy for simple SUM and COUNT operations on only some of the values in a range, but is there a more general version that would allow me to plug in any other function I ...