Filters, as used in computing, serve a similar function to those used in the physical world - they separate one type of item from a larger grouping of items.

learn more… | top users | synonyms (2)

0
votes
3answers
35 views

Excel filter duplicate values in column A and filter out rows which have column C blank

Total n00b here. How to filter duplicate values in column A and filter out rows which have column C blank. I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next ...
1
vote
1answer
42 views

Why changing DNS won't bypass the internet censorship

Reddit is blocked by my ISP. :( I have tried changing my DNS Servers to 8.8.8.8 and 8.8.4.4. Both in my computer (Windows) and my Router (TP-Link Router). Some say that it will bypass the internet ...
0
votes
0answers
44 views

iFilter msg content not retrieved

I'm using Windows Server 2012 (64bit) and am investigating using iFilters as a means of extracting and indexing data from various file types. One of the file types is .msg (MS email). The iFilter is ...
0
votes
0answers
21 views

Automate the process of Setting Preferred Decoder as ffdshow For Windows 7

I want to automate the process of: First: installing ffdshow, Second:Then set all possible formats decoder to libavcodec in the ffdshow video decoder configuration and Third: finally set ffdshow ...
0
votes
1answer
83 views

Best way to block websites with PowerDNS?

I'm working on a DNS filtering system for my household. I have a blacklist from MESD with a list of both IPs and domains, but am not sure how to block them with the blacklist. I thought about using ...
0
votes
1answer
20 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
36 views

Why doesn't collapsing duplicate rows work for me?

I'm trying to filter out duplicate rows in my excel sheet By selecting column B and checking unique records only I expect this to collapse to a single row, but this isnt happening. What am i doing ...
1
vote
0answers
14 views

Thunderbird filters, make log pop up OR tab appear for added to mailbox?

I have several filters set up for incoming email, and yes I do know I can manually look at the Filter Log to see what was filtered. But I want something more automatic and more in-my-face. Either... ...
0
votes
1answer
16 views

Count the number of times a value/string is in a column when other columns are filtered

I am trying to count the number of times a value/string is in a column when other columns are filtered. Example: I want to be able to filter any column, A through V, and then count how many times a ...
0
votes
0answers
72 views

Adblock filter not working in Safari

I've added the following filter to Safari (7.0.3 OSX) to block web fonts: .woff| which, if I'm not mistaken, should block all the URLs that end with ".woff". However, this doesn't seem to be ...
0
votes
0answers
7 views

Claws Mail filter rule when `to` is the same as `from`

Is it possible to have a rule for filter that will test if to email is the same as from?
1
vote
1answer
68 views

ffmpeg does not recognize any audio filters

I am trying to reduce noise from the audio files I extracted from videos. The objective is to recognize speech so I was trying to filter out the frequencies above 300 and below 3000hz. I tried to use ...
0
votes
1answer
94 views

How to delete entire row when A1:A100000 columns are duplicated

I have to filter quite big data (102858 rows, 9 columns). The idea is that between these rows (URL addresses) are a lot of duplicates. A1:A102000 contains URL addresses with and without comments. For ...
0
votes
1answer
90 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 ...
0
votes
0answers
17 views

Thunderbird message filter to delete certain recipients from received emails

I receive emails forwarded to me by an external exchange server. The server forwards mails for an old email address to a new email address. The way this is done leaves me with an email, that contains ...
1
vote
0answers
55 views

Simulate Photoshop-like filters within Flash/AS3

Artist specified multiple filters and their properties for text field within Photoshop. I (as a programmer) need to duplicate the visual appearance of text field exactly as it looks within Photoshop, ...
0
votes
0answers
74 views

Add background music at specific time period in mp3 files using ffmpeg?

I want to add background music after every 5 seconds in .mp3 file using ffmpeg. I have 2 audio files : input1.mp3 of 5 seconds and input2.mp3 of 4 minutes 04 seconds. I want to add input1.mp3 after ...
0
votes
0answers
11 views

Search email on Gmail where the attachment is not saved in GDrive

I am using the web-based Gmail and I have plenty of e-mails with attachments. Now I am trying to save them directly on my Google Drive (GDrive) using the Google biuilt-in feature, but I still have ...
0
votes
1answer
36 views

How to create drop down column OR filters

I have a worksheet (in Excel 2003) that has a number of cross-reference cells, for example: 1 Red|Green|Blue|Yellow|Any|Information 2 X | | | | |.... 3 X | | | | X ...
0
votes
0answers
33 views

Windows program for filtering available fonts (like Adobe Type Manager)

I'm looking for a program (for Windows 7/8.1) which would be able to filter installed fonts in Windows so when I use some other programs and I'm trying to choose of some installed fonts, I wouldn't ...
0
votes
0answers
34 views

Excel Auto-filter Modifying Filtered Rows

When doing auto-filter, how to I ensure that changes will only affect the filtered rows? It seems to be a hit-miss thing. Ideally, when auto-filter is on and you do a Select All, all changes should ...
0
votes
0answers
44 views

How do I disable Magnifier's “smoothing” filter in Windows 7?

I would prefer to have a "nearest-neighbor" scale mode in the Magnifier (where each original pixels is rendered as a large square, not blurred between eachother). Is there an option to change that, ...
0
votes
1answer
139 views

Advanced filtering leaving on unique values and removing duplicates

On the spreadsheet there are two subsets of data that are separated by color based on where I pulled the information from. Within these subsets are duplicate entries. I do not want to simply remove ...
1
vote
0answers
24 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
0answers
107 views

SMTP blocking a legit email, no way to contact yahoo or anyone about it?

Very frequently, I have trouble emailing from Yahoo to people with their own domain. For example, when I send an email from myname@yahoo.com to someoneelse@theirowndomain.com, I'm getting a bounce ...
1
vote
0answers
333 views

Scale (or center) watermark with ffmpeg to same resolution as output file

I want to have the watermark scaled to the same resolution as the output file. How do I do this? Alternatively, how do I center the watermark in the middle of the output instead? Here is what I have: ...
0
votes
0answers
58 views

Search Everything: Additional filter parameters?

In Search Everything, the famous Windows NTFS file search engine, in its last incarnation 1.3.3.658b we can create custom filters by defining a list of file extensions. My question is: Is it also ...
0
votes
0answers
53 views

Filter excel pivot table using date range

I am exporting an MS Project file into an Excel spreadsheet. I would like to be able to pivot my tasks by assignee, by task etc. I would like to be able to filter the tasks such that if the start ...
1
vote
1answer
40 views

In an IP filter, where does the IP I'm trying to block goes: source or destination?

I'm trying to block a certain site/ip-address (http://122.160.230.125:8080/vta/redirectedPage.do) from opening. I figure (?) that if I could put 122.160.230.125 in my router IP Filter settings I ...
1
vote
0answers
40 views

Using electrostatically charged air filters on computer fans? Will I just be blowing charged particles into my case?

I've searched long and hard to try to find a straight answer to this question, but there seems to only be information on how electrostatically charged air filters work (you know, the kind you put on ...
1
vote
0answers
212 views

Pivot Tables - Filter Behavior, Limiting Filter Drop Downs Based on Previous Filters

I am working in excel 2010, and I have a question about pivot table filter capabilities / limitations. I tend to use complex, extensive pivot tables for data analysis/data accuracy on huge datasets, ...
2
votes
1answer
169 views

Is there a way to redirect certain URLs to specific web browsers in Linux?

I'm using Chrome as my default browser in Ubuntu 12.10. I need to use Firefox for business purposes (certain websites pertaining to my work only work with Firefox). Is there a way to force Ubuntu to ...
1
vote
1answer
40 views

Where does Thunderbird store 'right-click' filters?

Context: Thunderbird 26 beta, Windows 7 One of the nice things about Thunderbird (and for me, one of the most intensely irritating) is the ability to create filters by right-clicking the sender's ...
0
votes
0answers
97 views

Excel Combo box to filter a table column

I have a table that I want to filter a column of 'team names' (D10 is the column header) using a combo box (which has a list of the 10 team names from another sheet). So, when I select a different ...
0
votes
1answer
62 views

How to delete days with no data?

I have the flow data for 49 years for 15 min interval. I've used pivot table to get the daily average value of flow. After copy-pasting from pivot table and using filter to remove the blank flow ...
1
vote
1answer
229 views

'Tag' column in a table in Excel, similar to Wordpress

I am really not a power user of Excel, so I hope my question would make sense. I need to use Excel as a "database programme" (even though I know there are other solutions actually built for that). ...
0
votes
0answers
75 views

Delete file if silence detect?

I'm using this filter "-af silencedetect=n=-30dB:d=2" in FFmpeg, and I'd like to know if is there a option or argument if was detected silence in audio don't generate it, if someone know how or know ...
0
votes
2answers
77 views

How can I filter data based on items in a list?

How can I filter entries containing any specific word in a list of words? For example, I have a list of road names in Singapore. Amoy Street, Singapore Ann Siang Hill Anson Road Arab Street Armenian ...
0
votes
1answer
40 views

How to filter an array of words in Microsoft Excel? [duplicate]

How do I filter an array of words in Microsoft Excel? For example, I have a big list of road names in Singapore and I wish to filter all entries in the Excel containing any road name in the list. How ...
0
votes
2answers
85 views

Microsoft Excel Filter function

Hi I need help with the Excel filter function. I need to filter entries containing short forms of words (for example "Rd" for "Road"), however the filter function for containing "Rd" would return me ...
1
vote
0answers
64 views

Filter/Redirect http requests based on URL in Ad-Hoc connexion

My computer (Windows7) is connected to internet via Ethernet, and I shared this internet connexion via WIFI (Ad-Hoc). Is it possible to filter/block/redirect URLs for specific MAC/IP adresses, for ...
1
vote
2answers
109 views

How can I remove certain parts of a word document?

I have a word document filled with Physics equations and annotations. I want another word document to be a copy of the first document but with the annotations removed. I have all the annotations in ...
0
votes
0answers
27 views

Filtering dates from different sheets

I have an excel workbook which consists of around 200 separate worksheets. Column A on each sheet is a date column. I need some vba which will give the names of all sheets that have a stipulated date ...
1
vote
1answer
204 views

How to filter rows which are blank rows from a specific column onward?

I have a file with thousands of rows and need to filter it. How can I filter rows for which all columns are blank after column X? The situation is as follows: I am working with a database of ...
4
votes
2answers
606 views

How to filter cells based on font color?

Someone sent me an Excel 2010 spreadsheet with more than 50,000 records with the request to review the "highlighted in red" records. My current method of scrolling with the assumption I have a keen ...
0
votes
0answers
29 views

WAN Access Issues on LAMP Server

I am running a LAMP server and having trouble connecting over the internet. I confirmed everything is working fine locally. All other PC's on my network can access the server over the LAN. The ...
0
votes
1answer
236 views

filter through one excel spreadsheet using data from another

I have 2 excel files. One holds some products that i need to put into a database but it doesnt have all of the information i need. The second file has all the information for these products but there ...
3
votes
1answer
410 views

Filter comma-delimited Excel column

I have an Excel sheet serving as a master spell list for a tabletop game. Each row (save for row 1) contains the data for a spell: Name, Target, Range, Duration, Function, Effect, Subject, Level, and ...
2
votes
3answers
789 views

In a spreadsheet, is it possible to separate rows into groups that will not change order when filtered?

I am trying to make row subgroups in my spreadsheet rows so that I can sort my data but have rows in any particular subgroup stay together. This is probably easiest to show with a picture. Sorting ...
0
votes
0answers
129 views

Dansguardian unblock website for subnet

What I try to solve is to unblocking www.youtube.com for just one subnet of my network. I'm running Dansguardian 2.8.0.6. together with squid on my gateway. Example: 192.168.1.0/24 --> YT ...