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
5 views

Validate range of values against another range of values in Excel

Similar to how CountIf validates a single value against a range of values (or, CountIfs validating a range of values against criteria), is there a way to validate a range of values against another ...
0
votes
0answers
17 views

What is the client's “open to LAN” port range for Minecraft? [duplicate]

Does anyone know what the port range for Minecraft LAN is? it appears to be a random port every time, but there must be some guideline (i.e. min - max). As far as I can tell min is ~5000 and max is ...
0
votes
1answer
16 views

Range extension for new blu ray

My man cave in in my shop ( metal building) 200' from the house. I have a RG6 line from the splitter to the TV and a CAT5 line from the router ( Belkin N600) to my computer. WiFi does not seem to ...
0
votes
2answers
45 views

Long Range Omnidirectional Wifi in Urban without line of sight

I want to share my wifi connection to my friends which are in all direction around me but less than 11km away. How can I achieve an omnidirectional wifi signal of about 11km. because there are many ...
0
votes
1answer
55 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
38 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
26 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
43 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
107 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
60 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
54 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
123 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
338 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
2k 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
1k 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
72 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
388 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
223 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
317 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
510 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
335 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 ...
3
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
335 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 ...
-1
votes
1answer
138 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
796 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 ...
4
votes
1answer
6k 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
864 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
9k 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 ...