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

How to add prefix or suffix to range of cells in Excel?

I have cell A in excel full of images name without the extension I want to add ".jpg" as a suffix to these ranges of cells however I need to skip non text cells by not adding anything. Any help to ...
0
votes
3answers
51 views

Excel 2010 Specific cells for formula input cell arguements

Col A Col B Col C Row 1 a a a Row 2 a a a Row 3 a a a I am trying to set a specific range in the COUNTIF function, =COUNTIF(range,criteria). Example 1: ...
-2
votes
1answer
76 views

Excel how to sum all cells with the same name

I have a workbook with 30 or more sheets. Specifically, each sheet may be an invoice, change order, etc. such that the format of each sheet is not the same as the next one. The named range Total on ...
-1
votes
1answer
205 views

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'...
1
vote
2answers
23 views

Find correspondent row in array

I've a product's list containing each product's weight. I've another table with ranges of weights, and each range has a different storage cost. I'd like to have a formula that identifies in which ...
3
votes
2answers
263 views

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 ...
0
votes
1answer
286 views

Insert formula if blank if next cell in row within range, but freeze data from previous cell/ remove formula

I have some users that are manually entering data from one excel generated from a reporting system and entering in that data into hundreds of cells per day. The format of the report generated excel is ...
0
votes
0answers
45 views

Counting Max values in a range of ROWS

I am using Excel 2013. I have seen and reviewed the "Excel Counting number of MAX values in a range" post/question that created the appropriate solution BELOW (in columns) but I have tried and ...
0
votes
0answers
73 views

Sumifs(): Limiting the sum_range and criteria_range as to optimize calculation speed when data is sorted.

I have a sorted data set that's about 50,000 rows long with data that looks like the following: In it I have about 3 columns similar to the total column shown here that performs a pretty simple ...
1
vote
1answer
103 views

Excel VBA to Standardize Names in a selected range

I am a complete novice at both excel as well these forums, and am attempting to piece together code that would allow a user to update a column of text entries. Basically what I was attempting to do is:...
-1
votes
1answer
76 views

How to expand a range of values to individual values separated by commas in MS Excel 2007 and 2010

How to expand a range of values to individual values separated by commas? Example 1: convert R1-R8 TO R1, R2, R3, R4, R5, R6, R7, R8 1-10 TO 1, 2, 4, 5, 6, 7, 8, 9, 10 I need these expanded range ...
0
votes
1answer
89 views

VBA macro crashes when using variable Ranges instead of fixed ones

I've tried to include comments with the code to make it readable, especially as I'm sure there are better ways of doing this! I have a table with purchases and sales for a specific product. E.g. ID ...
0
votes
1answer
37 views

Sum of Excel Range Between Dates

So I've struggled with this problem several times and usually just end up giving up on it, but this time I want to solve the problem once and for all. I have a straightforward table as follows: Date ...
2
votes
3answers
124 views

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
votes
1answer
29 views

How to copy range from an unactive workbook

I'm simply trying to copy and paste between workbooks in VBA without first activating each workbook that I want to perform actions on. My code stores the active workbook and sheet in variables before ...
0
votes
0answers
34 views

Auto expand does not work between sheets in excel 2013?

I have a sheet with values from an access DB. As the DB expands, so does the sheet. But I also have links in another sheet to the first one, and they do not auto expand. Can anyone help me figure out ...
0
votes
1answer
38 views

Excel 2010 Array (CSE) Formula: How to remove a part of contiguous (adjacent) range

I would really appreciate help on the following question: Is there a way to write a formula that removes a segment from a contiguous range? For example, say there is a formula =COUNTIF((A1:A100),">1"...
1
vote
1answer
670 views

Excel VBA - Conditionally format a cell using 2-color scale based on 2 values (max/min) on other cells

I'm trying to write VBA codes to conditionally format (2-color scale) cell A1 based on its value that between is >= cell A2 and <= cell A3. I'm using cells A2 and A3 so I can change the specific ...
0
votes
1answer
21 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
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 work,...
0
votes
2answers
233 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
203 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
111 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
46 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
85 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
273 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
212 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 ...
2
votes
1answer
472 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., =SUM(SUMIF('2014-02'...
4
votes
1answer
1k 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
3answers
4k 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
3k 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
99 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 ( http://blog.degree.no/2011/10/permanent-vpn-connection-...
-1
votes
1answer
591 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
1answer
5k 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
431 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 土 14:...
1
vote
1answer
589 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 ...
2
votes
1answer
379 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 ...
4
votes
1answer
7k 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
654 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
5k 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
140 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
1k 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
5k 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 ...
9
votes
1answer
11k 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
111 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
1k 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
10k 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 ...