Questions tagged [range]

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

112 questions
48
votes
7 answers

Why is the range of a mobile Wi-Fi hotspot shorter than that of a router?

There is something I would like to understand. A Wi-Fi router has a range of 30-40 meters (100-130 feet). A mobile hotspot (access point) generated by a smartphone has a range of +- 10 meters (30 feet). My question is, if a smartphone can only…
Greelings
  • 723
  • 1
  • 6
  • 12
24
votes
2 answers

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 used the following ways, three arguments command…
16
votes
5 answers

What are the valid public IP address ranges?

There are a number of lists on the web that define all valid public IP addresses ranges but they don't seem to be very accurate. The most common list Ive found is show below. This list however doesn't include addresses in 191.236.x.x even though…
PeterJ
  • 314
10
votes
2 answers

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 the picture below, you have to give a range. Is it…
Terry
  • 1,719
7
votes
2 answers

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 It should work as follows: > cat input_file | foo…
jrdioko
  • 13,195
5
votes
1 answer

Using wget and manually passing 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 fails to do so with the following error when debug mode…
4
votes
1 answer

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 Googling has not shed much light.
3
votes
1 answer

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) numbers. Column B extends down to about 5 thousand…
Antonio Oliveira
3
votes
5 answers

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 similar filtering on a Range where the result is…
user24752
  • 293
3
votes
4 answers

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 the important dates column, it is…
3
votes
3 answers

Excel Switch Statement with Ranges

I need to populate a column (say A) based on the value in another (say B). However, B can have a range of values and I need to populate A based on where the value in B falls. I've tried the following and it just returns TRUE. Any thoughts on how I…
Tom
  • 31
3
votes
3 answers

Define a range using a formula

A simplified version of my problem is that on a different sheet called Sheet2 I have data that I want to average: =AVERAGE(Sheet2!$A$1:Sheet2!$A$100) Depending on where the code above is used I need to exchange column A for another letter, for…
litmus
  • 131
3
votes
1 answer

How to properly set left and top border of a range in Excel when the range is at the top left corner?

I have a range A1:B3 in Excel and I've given a border to it. However, the top and left border look a little bit thinner than the right and bottom border. See below image, I set them all to have the same width. How to make the width same?
Just a learner
  • 501
  • 2
  • 6
  • 21
3
votes
2 answers

How does the IP range work to find a specific computer on a network with separate network addreses?

This is a question from a homework assignment that I’m confused on. I’m stuck but I think the answer is “manufacturing” (192.168.1.64). You are the network administrator for an industrial machinery manufacturer in Florida. The company manufacturing…
2
votes
3 answers

How to use wildcards to find the years between 1900 and now

I want to know the number of times that any year from 1900 through the current year is mentioned in a Word file. I know how to use a wildcard expression to do this in two steps as follows: <(19[0-9]{2})> to find matches 1900-1999 <(20[0-9]{2})> to…
RJo
  • 573
1
2 3 4 5 6 7 8