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].
109
questions
0
votes
1
answer
41
views
Copy single cell value in range if multiple criteria is met
I am trying to create a map to see who is positioned where. I am quite stumped on this as I cannot get a single output from my attempts and also I have only achieved FALSE and Blank responses.
I want ...
0
votes
2
answers
79
views
Converting range of times in any format to hours and minutes
In Excel, I'm looking for a simple way to convert a 24-hour format time range (in various formats) to hours and minutes.
For example, I might have different hour/minute range formats:
9-12 // result ...
- 101
0
votes
0
answers
17
views
Highlight range when press another cell
If countif example "done" range example from A1:A10 and result appear in cell B1
If result =4 .
I want when click B1 .. the cells in range that contain "done" highlight and color
0
votes
1
answer
17
views
Trying to Sum data within a selected time period (in decimal years data)
Snip from Excel showing data I am using, I am trying to Sum column "Cum.Fire" but only want to select data starting from 2019.667 in the "time in decimal column".
How do I do this?...
- 1
-1
votes
2
answers
56
views
Excel 2021: Filter a multidimensional range as a single column
I have an excel file with 8k+ lines and 20 columns. I have already added a filter on the 9 first columns to display only the lines that fit my needs. The 11 remaining columns are a split of a single ...
- 3
0
votes
1
answer
464
views
Excel - getting a range from a list
How can I get a list of ranges that belong to a certain value.
Example, how to go from this:
Value
Id
1
a
2
a
3
a
4
b
5
b
6
a
7
a
8
b
9
a
10
c
to:
Range
Id
1-3,6-7,9
a
4-5,8
b
10
c
or:...
0
votes
0
answers
19
views
Search for files with Tags that include a number within a range?
New here 👋🏼.
I'm on macOS (Monterey). I've come up with a Keyboard Maestro macro that reads the ProjectData or MetaData of a Logic Pro project to find its tempo, then tags the project file itself ...
1
vote
0
answers
52
views
How create increment column in visidata from a set value, not for 1?
If I have I frame with 10 rows, and I create a new column with za and then use gi I get a range column from 1 to 10, but instead of that I want to get a range column from 15 to 25.
How can I get that?
- 11
1
vote
3
answers
4k
views
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 ...
- 11
0
votes
1
answer
485
views
How to create a regex for a Notepad++ search over a range of integers in a CSV file rows
I have a have CSV file containing entries with ranges like [12, 22[ that I want to replace with ranges like [12; 22[.
What is the regex to use in Notepad++ in this case ?
sample row of my dataset:
1,2,...
- 103
0
votes
1
answer
477
views
How do I limit an Excel formula in a row to a specific range of data?
In an Excel workbook I have ranges, e.g. from ABA through ABS in one cell, and would like to decouple each them and add every code between those, like on the picture. No VBA method though.
Managed to ...
- 345
0
votes
1
answer
235
views
How to use a non-contiguous range for diagram?
(Similar to question How do I select non-adjacent ranges in libreoffice calc?, but not identical)
I have a time-based series of data (date&time, value), and I have a diagram showing the data.
The ...
- 547
1
vote
2
answers
567
views
Normal distribution for a given range of numbers in Matlab
My question is about estimating a normal distribution for a row of points of an interval that are extracted from the data, just knowing the maximum (xmax = 200) and minimum (xmin = 100), to distribute ...
1
vote
0
answers
54
views
What's the Accept-Ranges Header working principle?
What's the Accept-Ranges Header working principle?
we know Accept-Ranges: bytes means the URL can be request by ranges.
I have several questions about it:
When Server return the URL HTTP response, if ...
- 107
1
vote
3
answers
368
views
How to make this VBA code relevant to a particular sheet(s) in my spreadsheet only?
Thanks to a piece of code from Contextures my spreadsheet now allows for multiple selections in a particular drop down list; when you select another value, it will add it to the existing values in the ...
- 21
0
votes
2
answers
2k
views
Display multiple row with data according to ID value
I want to ask as well about this.
For example:
One ID has multiple rows with value (one row is equal to one dependent).
So ID:001
Has 4 rows (4 dependents)
001 | Marie | 03/23 | Female
001 | Raffy | ...
- 103
0
votes
1
answer
107
views
Inconsistent Column Range
Created a macro on a table with rows which auto expand depending on what is input. The original range of column D which i am working on is D2:D12. On some occasions, the range will go beyond D12. It ...
- 19
0
votes
2
answers
41
views
Return value based on date
I am running into an issue where I have various sectors that have been scored differently depending on the year. See example below:
2017 2018 2019 2020
...
0
votes
2
answers
181
views
How to fill cells in the Excel with serie, range or similar?
How I fill selected region (column) with needed numbers?
I have very long columns, so I am not able to use that small rectangle in the bottom-right-corner and drag it down (autofill or how to name it)....
- 23
1
vote
1
answer
63
views
Find how many sets of numbers within a range exist
I have a column of 1 million numbers that were generated randomly. They range from 1 - 1000, and each have two decimal points. There are duplicates of numbers obviously.
I would like to create a ...
0
votes
2
answers
65
views
"Advanced" VLOOKUP range
I am having some problems with the problem as stated:
I have a worksheet containing column A with different well names. In a second and third column, there are top and bottom depths of a geological ...
- 1
0
votes
1
answer
756
views
Use table column names as range in index array?
In an Excel 2016 table:
I have a formula that I use to check if parent records have the right 'Use With' values (if a child record has a 'Use With' value, then it's parents must have it too). More ...
- 137
46
votes
7
answers
30k
views
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 ...
- 673
0
votes
2
answers
247
views
How to conditionally concatenate a range with VBA?
In my work, every end of the month I have to review data saved in spreadsheets like the image. The only data that interests me is to check the value of L column and obtain the data in the BS column. ...
0
votes
1
answer
67
views
Terrible WiFi range
My house was built in 1886, with knob & tube wiring, no ground. My wired ethernet runs at 600MB down & 30-40 up. Wireless is another issue. I have a top of the line Nighthawk wireless ...
- 1
0
votes
2
answers
396
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 ...
- 78
2
votes
2
answers
2k
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 ...
- 432
0
votes
1
answer
26
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
203
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
3
answers
14k
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 ...
- 345
0
votes
1
answer
1k
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 ...
- 2,038
3
votes
3
answers
288
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 ...
- 141
3
votes
1
answer
562
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 ...
- 491
0
votes
4
answers
7k
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 ...
- 1
0
votes
2
answers
2k
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
375
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 ...
- 23
0
votes
1
answer
2k
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 ...
- 183
1
vote
1
answer
2k
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 ...
- 31
0
votes
1
answer
895
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 ...
- 179
0
votes
0
answers
36
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
728
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/...
- 11
0
votes
1
answer
95
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
692
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) ...
- 11
0
votes
2
answers
2k
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
1
vote
1
answer
378
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 ...
- 11
2
votes
2
answers
484
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:...
- 141
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
1k
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 ...
- 7
1
vote
1
answer
150
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 ...
- 15
0
votes
1
answer
259
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 ...
- 133