A range, for computers, is a set of data. If you're referring to signal range of a device, try using [tag:signal strength].

learn more… | top users | synonyms

0
votes
1answer
12 views

How do regular expressions work in htaccess to redirect an IP range

I've been trying to redirect an IP range from one link to another. I can do it for a single 256 address block: RewriteEngine On RewriteBase / RewriteCond %{REMOTE_HOST} ^111\.111\.111\. RewriteCond ...
0
votes
2answers
33 views

WIFI connection?

I would like to ask a question about how WIFI connection works. I couldn't find an answer on the internet. If both devices are within WIFI range of each other, there, of course, would be a connection. ...
1
vote
1answer
20 views

calc: Extract string from range of cells

I´m trying to figure out a easy to understand way to extract a string (that is in a range of cells) from a range of cells... That is the range of cells I have to look for a specific string (in a ...
1
vote
0answers
35 views

Wifi and Bluetooth Monitoring Range

Im trying to monitor bluetooth and wifi probe requests. Im very new in this topic and not sure about a few things: Bluetooth: Is it correct that the bluetooth class of my monitor device doesnst ...
1
vote
0answers
54 views

Batch check if IP is within specific range

I'm trying to make a batch script to get local IP-address of active NIC (could be wireless or local). To get IP adress I have used following line: FOR /F "delims=[] tokens=2" %%a in ('ping -4 ...
-1
votes
1answer
34 views

Finding the largest value in a 2-dimensional range and returning the column header

I've been struggling to find a solution to locating the maximal number within a 2-dimensional range and then looking up the column header that the maximal number falls into. For example: I'm ...
0
votes
0answers
61 views

Reference last cell not only in a row or column, but in a range

all users, especially Jerry Beaucaire. I was reading this link when I stumbled upon his answer Here is the link How to refer to the last cell in a row in Excel? And Jerry Beaucaire answered it like ...
0
votes
0answers
40 views

How to wget range that fills a PHP URL

I try to wget from 1 to 724.. When I try this line in the terminal : wget http://exemple.fr/resultats.php?ID={1..725}.html everything works fine except that the pages downloaded are no filled with ...
2
votes
1answer
92 views

Sumif range of criteria

I've checked different questions and answers on the site, but couldn't find what I'm looking for. I try to have a sum of values, using multiple criteria (OR): When I use, e.g., ...
3
votes
1answer
200 views

Print range - print from page x until end of document

Is there any way in Microsoft Word in the print range box to print from page 3 for example to the end of the document without entering the last page number? I've tried the likes of : 12-* 12 onwards ...
0
votes
3answers
927 views

Lookup range of words in range of sentences

Based on the following example: I want to look up for words from the $D$2:$D$6 range in sentences from the $A$2:$A$8 range and use the value from the side column (here Tag). So far I'm doing this: ...
0
votes
1answer
530 views

Excel summing named range

I have a workbook with many sheets in it. I want to sum column C2:C50 on each sheet. However, in the future I anticipate having to sum the range C2:C?, and rather than have to go into each sheet to ...
0
votes
0answers
67 views

IP range in command line

I am looking to use powershell and task scheduler in windows 7 ultimate 32 bit to redial vpn should the vpn connection drops. I found a scrip ( ...
-1
votes
1answer
313 views

Python to see if a file falls into a date range [closed]

I have a script that I want to have an if statement check if a file falls between several specified date periods as it searches directories. I have been able to get the time in %Y-%m-%d format for the ...
0
votes
1answer
209 views

monthly totals comparing two date columns, Excel 2010

How can I calculate a monthly total of the courses completed for the month ONLY when they were due for that same month (sometimes students are late and sometimes early)? The spreadsheet has a column ...
2
votes
1answer
3k views

How to check if cell contains a value of another cell

Here is the scenario: On column A each cell has random text within it (names, address, account numbers, etc). Column A extends down to over 40 thousand rows. On column B I have a list of (account) ...
0
votes
1answer
266 views

org-mode: Specify the clocktable time using the range format

I expect to be able to make an Emacs org-mode clocktable using the same range format as normal org-mode, but it doesn't work. How can I specify a duration like "[2012-11-10 土 13:00]--[2012-11-10 土 ...
1
vote
1answer
483 views

Excel data range - to sum series within date range

I have a set of data that I would like to manipulate but my problem is not straight forward. In this data I have date ranges that include multiple entries of the same date on some days and not on ...
1
vote
1answer
289 views

Where can I find the complete list of valid syntax valid for defining a range within Excel?

I am looking for an exhaustive list of valid syntax for a range with in MS-Excel, as examples here are some I know A1 - The First Cell A1:B2 - The four cells A1, A2, B1, and B2 A1,B2 - The cells A1 ...
0
votes
0answers
2k views

Excel defined-name range with `end of column` mark

Normally we define a range bay the row & column of the begin and end cell, e.g. A1:A11 I wonder if there is a way to define the range which has end-of-column marker, e.g. A1:A~ where ~ stands for ...
2
votes
1answer
5k views

Using wget and manually assing Range header

I would like to download a range of a file which I have explicitly defined. As far as I know: wget --header="Range: bytes=1024-2048" http://www.example.com/file.tmp should run well. Yet, it ...
0
votes
2answers
258 views

Conditional Formatting Non Contiguous Ranges

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting Cell Value is equal to =G7, colour ...
3
votes
5answers
3k views

Excel formula - querying a Range that results a Range

I have a Range in Excel (B3:C8) from which I want to filter out the English persons. In SQL this would be dead simple: SELECT Persons FROM [myTable] WHERE Nationality = 'English' How can I apply a ...
-2
votes
1answer
135 views

How do I create a range from a cell value?

For example: A B 7926 3 FROM =COUNTIF(AQ$7926:AQ7970,"=0") 7926 3 FROM =COUNTIF(AQ$7926:AQ7971,"=0") 7926 3 FROM =COUNTIF(AQ$7926:AQ7972,"=0") 7926 3 ...
4
votes
1answer
666 views

Linux: Print specific character range in each line

What is the most straightforward way, using Linux command line utilities, to print a specific range of characters for each line read on stdin? For example, for this input file: 1234567890 0987654321 ...
5
votes
2answers
2k views

How can I specify a sheet as range in Excel?

I want to apply conditional formatting on a sheet. I used to do Ctrl + A and then apply the formatting, but when i insert new cells or rows, this isn't included in the formatting. As you can see in ...
3
votes
1answer
5k views

list files numbered in a specific range

I have a set of files in a directory numbered as follows: file1.txt file2.txt ... file30.txt ... Now, I'd like to run a command on a specific range of files, lets say 18 through 31. So far I have ...
1
vote
1answer
109 views

Extending a range of fractions

I'm trying to fill a range with fractions i.e. 1/3, 1/5, 1/7, 1/9 etc. When i try to drag the fill handle down it gives me all kinds of odd results. e.g.-1/8, -1/5, -2/7 etc. Any ideas on how to get ...
1
vote
3answers
808 views

How can I detect if a range of cells contains only identical values or not in Excel?

I have a range of cells and I want a formula that says if all these contains the same values or not. Usually for two cells I would use if but I want a solution that would work for ranges. I don't ...
3
votes
4answers
8k views

Excel: Finding a value in a range of values

In my Excel document, I have one sheet containing a column of important dates. In another sheet I have a list of all dates. I want to conditionally format that list such that if the date is present in ...