The tag has no wiki summary.

learn more… | top users | synonyms (2)

-1
votes
0answers
20 views

Excel Weird with Filter & Match to get 1st result from filter

as view in this Forum from the Excel sheet Get first data after Filter Data 2 3 4 5 6 7 8 9 10 11 12 13 ...
1
vote
0answers
10 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
11 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
32 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
5 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
43 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
50 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 ...
1
vote
2answers
61 views

How can I search for files that are either compressed or uncompressed in Windows Explorer?

I know that Windows explorer can colorize the NTFS compression state of a file, in both the regular and search views. How can I specifically filter/search for files that are compressed or ...
0
votes
1answer
19 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
7 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 ...
0
votes
1answer
24 views

How to prevent all-filtered-out row label values from appearing in a pivot table?

I have a pivot table in MS Excel. For the same of example, suppose the basic data has 3 columns: Name: A string. CountMe valued either 0 or 1. Year an integral number. Tokens the data we're ...
1
vote
0answers
26 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, ...
1
vote
1answer
67 views

ffmpeg: adaptively stretch contrast

Consider a (color) video recorded under poor conditions. Its frames' brightest pixels are well below pure white, its darkest ones well above pure black. Can each frame's contrast be stretched closer ...
0
votes
0answers
47 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
7 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
25 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
22 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
21 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 ...
1
vote
2answers
27 views

Excel compare cells in columns A and B, show in column C cells only unique to column A

I know there's a formula for this in Excel but I can't get it right. I've got a list of 7000+ names in column A, and a list of 4000+ names in column B. Some are duplicates, appearing on both column A ...
0
votes
0answers
30 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
41 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
14 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
95 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
124 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
40 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
33 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
33 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 ...
0
votes
0answers
37 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 ...
0
votes
2answers
108 views

Powershell: gci filter with compact output

I want to find files recursively, and for that I am using > gci -name -filter *.py -r Option -name gives only the file name, to get one line per item found, as required. But the items that I get ...
1
vote
0answers
148 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
123 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
35 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
5 views

Rule to combine hide and protect?

I am syncing two drives with rsync --delete-excluded but I would like to ignore-and-not-delete some folders. Now my filter file looks like this: hide ./journal protect ./journal Normally I would do ...
0
votes
0answers
67 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
59 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 ...
0
votes
1answer
75 views

Process Monitor capture filter (or scripting)

As you know, Microsoft distributes the Russinovich extremely powerful process monitor. It captures a lot of system events and has a filter to show only some of them. I want to record a rare fault at ...
0
votes
1answer
121 views

Excel tables: Tag collumn in table

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 sollutions actually built for that). ...
0
votes
0answers
59 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
70 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
36 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
66 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
57 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
79 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
24 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
96 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
300 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
27 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
103 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
308 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
397 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 ...