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

87
questions

**0**

votes

**0**answers

15 views

### Formula to see if a date is before, during or after a specific date range

I am trying to see if a date is before, during or after a specific date range.
For example:
A1 16/01/2020
A2 01/01/19 B2 31/12/19
A3 01/01/20 B3 31/12/20
A4 01/01/21 B3 31/12/21
I need a formula ...

**0**

votes

**2**answers

69 views

### Find Non-Matching Values Between Multiple Ranges

I am looking to see if there is a formula only (no VBA) way to find the values in a list of constants that are not in a range; and can be dynamically adjusted for different lengths of lists and with ...

**2**

votes

**2**answers

125 views

### In Excel, can I “splice” multiple Dynamic/Spilled Arrays into a single Dynamic/Spilled Array?

IN A NUTSHELL
I have four (say) columns of data, each a Dynamic/Spilled Array. I'd like to "stack" them into another column so as to produce a single Dynamic/Spilled Array comprising the "splice" of ...

**0**

votes

**1**answer

18 views

### Excel insert selected range

I have a cell A1 with list (GROUP 1, GROUP 2, GROUP 3) and 3 groups of names (E1:G7).
I would like to select for example GROUP 3 and it would then printout all names in that group in cells C2:C7.
...

**0**

votes

**1**answer

35 views

### Counting the occurence of active durations by month and into a graph

Lets assume I currently have a spreadsheet that holds the dates of members at a crossfit gym and the duration of their memberships.
Date Started Date Ended Member Name
11/27/2019 12/19/2019 ...

**0**

votes

**0**answers

31 views

### Excel: normalizing an erratic timestamp

I have two different streams of data for a piece of equipment. One generates a datapoint every 15 minutes, and the other generates a datapoint at irregular intervals.
I would like to find the ...

**0**

votes

**3**answers

317 views

### VBA to check if all cells in a range are empty before proceeding further

I would like to apply a check before executing next lines of code.
I wrote a simple structure like this, but it checks the first cell in range and if that cell is empty it goes to executing next step ...

**0**

votes

**1**answer

521 views

### What is the best way to pass an Excel range to a user defined function?

I pass a big range from an Excel spreadsheet to the parameter ExcelRange of a user-defined function (UDF) written in VBA.
I can declare the parameter ExcelRange As Range and then convert it to ...

**3**

votes

**3**answers

259 views

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

**2**

votes

**1**answer

75 views

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

**0**

votes

**4**answers

72 views

### Determine if values are +/-10% of each other in excel

Hello and thank you in advance. I'm trying to put together a formula to determine if a series of values, e.g., 22.1, 23.4, 22.5 (up to 12 different numbers) are within +/-10% of each other. I've tried ...

**0**

votes

**2**answers

544 views

### Formula for Index/Match with multiple criteria WITH date range EXCEL

I am attempting to write a formula that will help pull data from column D into column H (currently populated but would be blank).
Logic is as follows: If any of the IDs in column A are in the range ...

**0**

votes

**1**answer

45 views

### Excel Find Number Within a Range

I have table in Excel with range of numbers, and next to it I wrote a group number that i want for this range.
I have the number 61 that i want to get his group number, which is 3.
What is the ...

**0**

votes

**1**answer

331 views

### WPA2-PSK [AES] login asks only for password, but I need username & password to login

I'm trying to connect to a 2.4GHz Wi-Fi network using a Netgear WN2500RP range extender. I connect to the range extender and through its web portal try to connect it with a secure network I have ...

**1**

vote

**1**answer

719 views

### Excel - dynamically expand range to include new rows from data file?

I have a spreadsheet that builds a chart from an imported CSV data file.
The CSV imports into Sheet1. Sheet2 formats the CSV data into data series for the chart which is in Sheet3. The chart is ...

**0**

votes

**0**answers

20 views

### WiFi range extender for the 5GHz band with removable antenna?

I need a WiFi range extender for the 5GHz band? Any suggestions? I need to be able put the receiving antenna outside and the transmitter inside.
TIA...Les

**0**

votes

**1**answer

214 views

### Win 10, search file with date created in date range and type of file pdf

On Windows 10, I would like to search for file which was created between 2/1/2018 and 3/1/2018 and has extention .pdf?
I know how to search for certain date range, but do not know how to add ...

**0**

votes

**0**answers

18 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

558 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
(in Excel). I have done my research and I found this instructive:
https://www.officetooltips.com/excel_2016/tips/...

**0**

votes

**1**answer

71 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

257 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

**2**answers

860 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

259 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

315 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

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

831 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

76 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

85 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

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

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

515 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

403 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

67 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

72 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

156 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

750 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

169 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?

**2**

votes

**2**answers

441 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

60 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

775 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

144 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

47 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

316 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

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

254 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

**2**answers

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

**5**

votes

**3**answers

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

67 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

381 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

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