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

1
vote
0answers
28 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
27 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 ...
1
vote
1answer
37 views

Excel automaticly adding an extra row which already contain formulas for the inputed number of years

I am looking to build a model, I would like is have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...
0
votes
0answers
43 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
37 views

Changing the number in Excel each time I print (and for a range)

Basically I want to add an addittional input box for range printing. Change the code from this thread: Changing the number in Excel each time I print to include another input box to determine the ...
0
votes
0answers
37 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 ...
1
vote
1answer
52 views

For a 4 storied house - 2 basic routers or 1 extra range router?

We have a 4 storied house with good number of walls and blockages. I have a D-LINK DIR 300 wall mounted at the center of the house but the signal drops to zero towards the corner in a floor above. ...
2
votes
1answer
76 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
149 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 ...
1
vote
0answers
50 views

atomatic (auto-re-calculate) fill series between 2 variables

I need to fill in column c series of dates or numbers in range of values in A1 and B1. Example: A1 B1 C 17/12/2013 04/12/2013 17/12/2013 ...
0
votes
3answers
646 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
294 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 ...
2
votes
2answers
250 views

Can a 192.168.50.0/24 network talk to a 192.168.50.0/23 network?

I currently have a local network running on the range 192.168.50.0/24, but I am running out of IP addresses to use. The plan is to change the network to 192.168.50.0/23 network, which will ...
0
votes
0answers
66 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
265 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 ...
2
votes
0answers
227 views

VBA - Arrayformula to a range stored as array variable

I need to apply a formula array to dynamic ranges in my spreadsheets, which for a fixed size range works fine using for example: Selection.Offset(2, 0).FormulaArray = ...
0
votes
2answers
273 views

WR1043ND + WRT54G for extending Wifi range. How can I set them up to seamless signal switch?

I have a tp-link wr1043nd connected to my modem. This router has wifi but the signal is not strong enough for some parts of the house. I wanted to use my old wrt54g to extend the signal. Ive tried a ...
0
votes
1answer
197 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
2k 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
235 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
473 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
274 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 ...
1
vote
1answer
597 views

Difference between port types

What is the difference between the three port types; Well-known, Registered and Dynamic? Namely, the difference in usage and port numbers associated with each category. Currently I understand the ...
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
240 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 ...
1
vote
2answers
359 views

Wifi Range Singal Boost through walls

i need to set up a private wireless network to stream video, between 2 buildings that are 300 meters apart. The problem is that there is not a LOS (line of sight). I thought of using multiple ...
1
vote
0answers
138 views

Ways to increase range of our present wireless router [duplicate]

Possible Duplicate: What's the best way to increase the range of my 802.11g router? We are searching for a solution to increase the range of our present wireless solution. We are ...
4
votes
1answer
613 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 ...
-1
votes
2answers
625 views

Does sticking a router in a box diminish wireless range?

If I were to secure my router by putting it in a plastic lockbox, would it dimish the wireless range of the router? I know a router can go through walls and floors, but I was wondering the ...
2
votes
3answers
398 views

Why I Am Limited By Wi-Fi Range?

I have noticed that my laptop does not connect to public routers in close range when signal strength is 2 out of 5. When i move it closer to access points then laptop accesses. Is there some kind of ...
0
votes
3answers
709 views

wifi speed and distance router

I want to try something a little different with the speed of wifi. I don't want to know what speed is in Mb or KB/s. I want to know my speed in m/s and I want to calculate the distance from laptop to ...
1
vote
1answer
574 views

Wireless Range Extender. Need upto 1 Mile line of sight [closed]

I've been shopping online for a good wireless range extender. I have a workshop located approximately 500 feet from my house (network) and a grain dryer which I would like to have wireless access near ...
0
votes
1answer
114 views

Switch with a big antenna [closed]

Not a code problem but an architecture/infrastructure one. I have a single board computer device (SBC) with an IP setup that currently chats to a laptop via a switch. All on a private network that ...
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 ...
1
vote
1answer
867 views

How to increase bluetooth dongle range

I just bought a blue-tooth dongle about 2 days ago but for some reason I can't get it to work when my cell phone is 10 feet away . It only works when I am within 1 metre range. According to what it ...
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 ...
3
votes
3answers
560 views

Is it possible to make a wifi g network link over 1-2km (1 mile) with some obstacles?

What type of antenna should I get ? Should I use an usb wifi dongle or a dd-wrt router for 2 laptops ?
0
votes
0answers
209 views

highest long range wifi g/n connection?

The IT shop at the shopping mall as a public wifi connection that I maybe connect to at my house almost 1 street near (really near) ... My laptops could not find the connection but I expect that a ...
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 ...
2
votes
3answers
3k views

How do I mount my Linksys WRT610N to maximize range and connection strength?

The current generation linksys routers have internal antennae. I currently house my primary router in my basement and would like to maximize the strength with which it covers my home. Is there ...
1
vote
3answers
798 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
2answers
887 views

Fastest wireless solution for home with the best range

I am looking for the fastest wireless (WiFi) solution with the best range for home. What would be the best solution? I have challenging situation with two thick floors.
2
votes
1answer
552 views

Do any wireless presenters really have a good range?

I've had a couple of wireless presenters (the little devices with a USB receiver which allow you to move PowerPoint presentations etc along remotely) and I've found that they're great when they're ...
7
votes
4answers
1k views

What's the best way to increase the range of my 802.11g router?

I have cable broadband, and as such the router has to be attached to a cable modem which also has to connect to the TV. That means the router is stuck in the corner of my house. This is good when I'm ...
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 ...