# 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].

**0**

votes

**0**answers

12 views

### Use a EX2700 wifi range extender's Ethernet for connection

I have a router connected to the Internet, an EX2700 wifi extender connected to that router's network, and a Windows 10 PC without a wifi adapter. Can I do this and if so what must I do to make it ...

**1**

vote

**0**answers

15 views

### How to perform automatic graph range extension in Excel (with a constrain)

I'm having a hard time trying to make a graph's range extend automatically. I have made my research and I found this instructive:
https://www.officetooltips.com/excel_2016/tips/...

**0**

votes

**1**answer

63 views

### Change a macro that only works if the range starts with an A1 or T1 etc. cell

I have a macro that works but I would like to change the cell range from
Set SearchRange = Range("E1:E12") to
Set SearchRange = Range("A21:A32")
I have made the change in the code but it won’t ...

**1**

vote

**2**answers

84 views

### Name and date range conflict

I'm working on a project and want to calculate in excel whether the date range would conflict for a specific user.
For example "employee" Bill Smith (cell B2) has a project from 10/17/2018 (Cell C2) ...

**0**

votes

**0**answers

45 views

### Range Insert Assistance

I have been using the macro below for a while now but need to make one small addition and was wondering if someone could kindly assist. I need the info. in one cell to be moved when it has a 15 at the ...

**0**

votes

**0**answers

49 views

### how to conditionally sumproduct between ranges of different lengths on excel 2011

I have a table with age in deciles fromm 40-110. each decile has 12 rows as the interval is 1 month. I have 2 rows of data against age =84 rows of data
I also have a set of reference values A & ...

**0**

votes

**2**answers

222 views

### Find value in a non-continuous range in Excel

Is there a way in Excel to look for a numeric value in a non-continuous range throughout the table?
Please refer to the image below:
I need to search for the value 2 between the range minimum value ...

**1**

vote

**1**answer

114 views

### excel worksheet range / prevsheet

very much a beginner to excel...
i need to get a cells value J1 from the first worksheet of the month named 2018-04-01 through to the lastest worksheet 2018-04-25
am able to do that no problem using ...

**2**

votes

**2**answers

134 views

### How to select a range from '[' to ':' and replace?

I have a document with a many looks like look something like:
[9/22/17 10:46 AM] xxxxxxxx: llllllllllllllllllll
[9/22/17 10:46 AM] Cc: cccccccccc
[9/22/17 10:46 AM] Me: bbbbbbbbbbbbbbbbb
[9/22/17 10:...

**0**

votes

**2**answers

850 views

### Copying and pasting values in Excel 2016 using VBA

I am a VBA newbie I need help with writing a function that I can call in a formula, the function should copy the values of a cell(This cell should not be a predefined fixed cell instead it should be ...

**0**

votes

**1**answer

637 views

### Vlookup range in multiple column

How can I apply the VLOOKUP function when lookup ranges and value in multiple column.
Data and result same but table range different. I need two different formula based on the following data and ...

**1**

vote

**1**answer

37 views

### Using Terminal to rename certain numbered files

I have a series of files numbered 1-20, and Terminal sorts them like this:
episode1.txt
episode10.txt
episode11.txt
episode12.txt
I want to rename the files 1-9 by inserting a 0 in front of the ...

**0**

votes

**1**answer

74 views

### Move a range used in a function after a specific number of rows?

I have a formula that is referencing a range. I want this range to move down one row every 20 rows as I copy the formula down. That is to say, the range needs to be the same for 20 rows, then move ...

**0**

votes

**1**answer

802 views

### Sorting ranges by time in excel

I have the following problem.
I use a macro to sort time values. But when I copy paste the time from a sharepoint list. It's written in the cell as for example "14:30". When I type the time myself ...

**1**

vote

**2**answers

1k views

### Macro to look up date in column range, insert row and paste data

What I want to do is to have a macro that will:
Detect, on page ("Original") the value of a cell ($E8, a date)
Go to another page ("Transfer"), (page name varies, but the appropriate page name comes ...

**0**

votes

**0**answers

289 views

### generate numbered list of computer-name's without foreach in powershell

Just wondering if there way a way to generate a numbered list of computers like this without using foreach, so that Don Jones would like me:
1..3 | foreach { "COMPUTER0$_" }
The output looks like:
...

**-2**

votes

**1**answer

189 views

### How to bulk download files in Powershell with URLs that have two variable numbers?

I need to download a large number (hundreds of thousands) of files from the website http://www.siaapm.cultura.mg.gov.br/acervo/memorial_imprensa/, and the URL pattern is http://www.siaapm.cultura.mg....

**0**

votes

**1**answer

43 views

### Create a list from a range of values in cells

Can someone help me with this ?
I would like excel to create a list depending on a range:
Range1: B1: 1 C1:5
Range2: B2: 10 C2: 15
I Column A4 and below :1,2,3,4,5,10,11,12,13,14,15
Range input will ...

**0**

votes

**1**answer

67 views

### How to populate data from one sheet to another by making a list?

I am trying to populate data from one sheet to another. On one sheet I have a bunch of different salespeople separated by activity for each month. I want to make a list on another sheet whereby if you ...

**0**

votes

**1**answer

118 views

### Find a text cell in a range dynamically

I am trying to find a cell in excel using a formula from a range.
The range will be as such:
╔═══╦═══╦═══╦═══╦═══╦═══╦═══╦═══╗
║ ║ A ║ B ║ C ║ D ║ E ║ F ║ G ║
╠═══╬═══╬═══╬═══╬═══╬═══╬═══╬═══╣
║ ...

**0**

votes

**1**answer

446 views

### Excel Ranges vs. Arrays

I'm having an issue where Excel seems to handle ranges and arrays differently. Please see the example below.
Why would Excel handle the Array {"Andy", "Dave", "Sally"} in a different fashion to Range ...

**1**

vote

**1**answer

165 views

### howto increase the range of WLAN - it must be a software issue - with stock firmware it was better

I own a Netgear R7000 router. After installing Advanced Tomato firmware, the range of WLAN decreased. Upstairs there is weak connectivity.
Do I have some sort of misconfiguration?

**3**

votes

**2**answers

157 views

### Get the list of the range of ips

I need to get all the ips that belong to a range/CIDR. What command, script (bash), or utility can I use for this?
IMPORTANT: I need the print full list of ips addresses
Example:
192.168.0.1-192....

**1**

vote

**1**answer

54 views

### Continous cell range in a filtered cells on another sheet or same sheet

I have a data source where I want to assign continuous cell range to the filtered cells only. For example, if I have filtered cell A1,A40,A79,A118,A157 and so on have a gap of 39 cells/rows and I want ...

**0**

votes

**1**answer

443 views

### Reference cell range on another sheet - Excel

I have 3 sheets, say they're "sheet1", "sheet2" and "datasheet". On "sheet2" have "$A$3" in cell B3 (this is dynamically generated), and on "sheet1" I want to create a function (eg sum or average) ...

**1**

vote

**1**answer

107 views

### Sparkline entire column of data?

I have a column of data, the number of rows may change often. I want to create a sparkline of the entire row of data without specifying the cell for last row because it'll change. How would I do it? ...

**1**

vote

**1**answer

829 views

### How to use a an address formula as the limits of the COUNTIF range

E.g.
=COUNTIF(M13:O24,"S3")
I want M13 to instead be the value $W$13 which is in a cell given by
=ADDRESS(1+12,11+MATCH(AG12, Plan!$L$12:$Z$12, 0),1,)
I want O24 to instead be the value $W$51 ...

**1**

vote

**1**answer

32 views

### How do I write a SUMIF formula for pricing?

I have an excel program used to price out paint and the "tints" used in the paint formula. What I'm trying to achieve is:
If the sum of cells B54:H54 is =0 then cell I54=0
If the sum of cells B54:...

**0**

votes

**1**answer

259 views

### Excel 2013 Wildcards on specific range and Sumif

I'm trying to use a wildcard limited to a specific range within a Sumif function.
Example:
I got these codes:
ABC-1
ABC-2
ABC-3
ABC-4
ABC-5
ABC-6
And I want to SUMIF from ABC-3 to ABC-5.
I found ...

**0**

votes

**1**answer

2k 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

**3**answers

194 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

**1**answer

1k 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 ...

**3**

votes

**3**answers

30k 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

**2**answers

51 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

**2**answers

365 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

**1**answer

989 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

**0**answers

295 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

**1**answer

428 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

**1**answer

817 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

**2**answers

669 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

**1**answer

63 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

**3**answers

404 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

**1**answer

50 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

**1**answer

52 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

**1**answer

2k 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

**1**answer

79 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

**1**answer

18 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

**2**answers

711 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

**1**answer

557 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

**2**answers

222 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. ...