# Questions tagged [range]

A range is an extent of values between its lower and upper bound. It can refer to a DOM Range, the Ruby Range class, the Python range function, Perl 5's `..` operator, Perl 6's Range Class, or PostgreSQL's range types.

**1**

vote

**3**answers

26 views

### Excel VBA - How to check if target is a named range. If yes, paste range

I currently have my excel coded to do the following:
Whenever various specific text strings are typed anywhere in column B, a corresponding named range will be pasted at a relative offset.
Instead ...

**-1**

votes

**0**answers

18 views

### How to handle Bold, Italic, underling text like whatsapp and jira does

I am doing feature like posting timelines In which use can change the font styles like BOLD,Ittalic,Underline .
I am following the same way that jira and whats app do,more of I am following jira.
...

**0**

votes

**0**answers

25 views

### NodeJs inverse boundaries (2D Collision)

Given the context, the following function limits an object to move inside a certain area:
Enemy file
Enemy.bound = function(x, y) {
return [Util.bound(x, 500, 1000), Util.bound(y, 500, 1000)];
};
...

**0**

votes

**0**answers

34 views

### date range picker dialog

Currently, what i wanted to achieve is something like this :
What i want to do:
Is this possible to create using the native android datepicker dialog or do i need to use a third party library?
...

**0**

votes

**0**answers

5 views

### VBA script copy and paste data from table into separate sheets

I am looking for some help with this macro. I have a table of data which I am trying to break up into separate tabs to make it more manageable to read. Column A contains the ID of the record and its ...

**-2**

votes

**0**answers

24 views

### Ranking values outside of an array in java

Is it possible to find the index of a value outside of an array. For instance say I have an array [a,b,c,d] and I want to find the index of e so that I can find a hypothetical range between b and e, ...

**0**

votes

**1**answer

23 views

### How can I find the number of values in a vector within a certain range of the minimum with R?

I'm a beginner to R and I'm trying to figure out how to find the number of values +/- 100 of the minimum value in a vector. I've tried:
>min(Vector)
>sum(yVec>(min(Vector)-100)>min(Vector)...

**0**

votes

**0**answers

44 views

### How to combine all ranges to range(0, 10) in python array?

My for loop is not looping for all because my range was only range(0,1) so how to solve this issue.. Please help :( Thanks!
def cleanString(newstring):
newstring = newstring.replace("!", "")
...

**-1**

votes

**0**answers

9 views

### Q1 If string starts with “&” or “#” then delete entire row and Q2 Round off number to 2 decimal place for a range

Below are my 2 questions explained -
Q1 Hi All, I want to delete entire row if the string begins with "&" or "#"
I am getting type mismatch error for the below code:
If Left("F" & i, 1) = ...

**0**

votes

**0**answers

42 views

### Error 9 occurring when trying to replicate SUMIF() function in VBA

I'm new at VBA and I have to automate a sheet. One of the columns needs to use the equivalent of this SUMIF() function:
=SUMIF($A$2:$A$193335, A2,$C$2:$C$193335)
Now, suppose I've acquired the ...

**-3**

votes

**0**answers

17 views

### How can I calculate the range of a column depending on a condition

I have a data frame as shown below (only few rows of more than 30k). I need to create another data frame which will have only 2 column, one of them is going to be unique values of column ['NO'] (goes ...

**0**

votes

**1**answer

21 views

### FullCalendar - Month view : Different behavior for selecting date ranges (no click and drag)

I wonder if there's an alternative way to select a range of dates in month view, without click + drag?
My idea would be:
1st. click: Sets start date.
On mousemove, date ranges highlight (up to the ...

**-1**

votes

**1**answer

29 views

### Google Sheet array range

I am trying to create categories of scores using the array formula in Google Sheets where 0-17 = low, 18-23 = moderate, and 24+ = high. My current formula works for low and high but I am getting "...

**0**

votes

**0**answers

16 views

### Matlab - How to plot range of a matrix transformation?

I have a matrix transformation T(x) with standard matrix A. A has two columns: a1 and a2. The range of T(x) is a*(a1) + b*(a2). How do I plot the range of T(x)?

**0**

votes

**2**answers

32 views

### Copy down in column

I have a problem with a part of a bigger VBA Macro, so no; I can not do this another way.
I want to copy a value down in an empty column, but only in as many rows as I have in the worksheet.
I want ...

**0**

votes

**2**answers

21 views

### Input range incorrect display of value

I am not sure if I misunderstood this part. I have created an input range wherein its default/initial value will be 15.
However if I run it, the range default value is 16.
<input type="range" id="...

**1**

vote

**2**answers

52 views

### How to get min and max values of ranges with numpy?

I wonder if there are specific numpy functions to get the heighest and lowest values columns of my ranges.
For ranges you can assume that every first dimension of my numpy array respresents the ...

**0**

votes

**1**answer

32 views

### Python - Using the random module to give you a value in the range of [0.0, 1.0), multiply it, then round it

import random
result = []
for i in range(0.0, 1.0):
[random.randrange(5000) for i in range(5)]
Trying to figure out how to, using the random module, obtain five values in the range from [0.0, 1.0)...

**0**

votes

**1**answer

39 views

### Scan a matrix and find the maximum value in Matlab between 2 ranges

I have a matrix in the form of a text file, I was hoping to scan it using MATLAB, and scan for the maximum value in between 2 points (1.5 and 2) and use that as a threshold.
I wrote a code but it ...

**-1**

votes

**0**answers

22 views

### Python - Using the random module to give you a value in the range of [0.0, 1.0), multiply it, and round it

import random
result = []
for i in range(0.0, 1.0):
result.append(i**5000)
Trying to figure out how to, using the random module, obtain five values in the range from [0.0, 1.0), multiplying each ...

**1**

vote

**0**answers

66 views

### Cannot invoke initializer for type 'Range<_>' with an argument list of type '(Range<String.Index>)'

Since Xcode 10 I receive an error message Cannot invoke initializer for type 'Range<_>' with an argument list of type '(Range<String.Index>)' at the return line in the code below, which is ...

**-1**

votes

**1**answer

54 views

### How can I use an element in a list as a parameter in range()?

So I have a for loop for i in range(0, arr[0]): and I want the stop parameter of the range() function to be variable based on the value of the first element in an array. When I do this, however, even ...

**0**

votes

**1**answer

30 views

### postgres array of range type check include

Is there a way to check if array of range includes another array of range in postgres
create table t(f int4range[])
insert into t values(array[int4range(1, 3), int4range(5,8)]);
select * from t ...

**0**

votes

**0**answers

47 views

### window.getSelection is not working correctly in Chrome

I am creating wysiswyg. My editor should add a box that contains selected text and its style.
I tried looking at window.getSelection() to get selected text and then I found getSelectionHtml function ...

**-4**

votes

**1**answer

33 views

### If a<x<b and C<y<d and x>y return value

Can some one explain if this is correct in JavaScript?
Or how to achieve that?
X - constant imput
y - constant imput
X>Y
If ay return value
Option 1: if (100=<x=<500 & 1=<y=<7) ...

**0**

votes

**1**answer

22 views

### Jython range issue

I am writing this program to take a list of input classes along with scores to with them. The goal is to print the class input along with the letter grade associated with the number score input.
...

**0**

votes

**2**answers

42 views

### copy all rows between two values where the first value is variable

I want to loop and extract all the rows between two different words (For Example, 56050067 and 56050068) that repeat in a column. This code get me just the first range
Thank you for intance
My table ...

**2**

votes

**2**answers

52 views

### Javascript Array sort and make same schedule as range of days

I'm provided with CSV of office schedules with dash range for the days with the same schedule.
For example, today is Thursday:
Mon 3:00am - 9:00pm, Tue - Thu 5:30am - 9:30pm, Fri 7:15am - 10:00pm,...

**0**

votes

**1**answer

21 views

### PageSetup.PrintArea for multiple ranges that are separated

I have the following code that exports the selected range in the worksheet as .pdf file:
'More coding above
With Sheet7
If (CheckBox1.Value = True And CheckBox2.Value = True) Then
...

**0**

votes

**0**answers

26 views

### Populating an array from named ranges using Index and Match

I am trying to populate cells with statements from a separate worksheet ('Data Validation') based on two conditions.
I have a drop down list (in U1) which defines one condition (Year 1, Year 2, Year ...

**-1**

votes

**0**answers

29 views

### Multiple Criteria to fill in ranges across several sheets using VBA [closed]

I am fairly new to VBA so my understanding is only limited. Hopefully someone can help me to input the correct code for this workbook.
Currently, I am building a staff record to monitor activity ...

**0**

votes

**1**answer

39 views

### Linux command to find and copy files which has number range in filename [closed]

I have to find and copy files which matches specified syntax:
Beginning with number 136 then range between 456 - 995 and followed by everything possible.
Syntax: ^136{456..995}*
Example filenames:...

**0**

votes

**2**answers

75 views

### Select only (merged) cells which contain specified column(s)

So right now I'm developing VBA macro which will be able to select only cells which meet specified conditions. The problem is I have nested list with multiple level cells. Each level is determined by ...

**-2**

votes

**1**answer

43 views

**-1**

votes

**0**answers

33 views

### Create set of sizes Matlab [duplicate]

I would like to create a set of all potential box sizes, that are based on the product sizes. I have 2000 products, and their dimension ranges are the following:
7 <= length <= 97 mm,
...

**2**

votes

**4**answers

63 views

### Determine if a range is completely covered by a set of ranges

How can I check if a range is completely covered by a set of ranges. In the following example:
WITH ranges(id, a, b) AS (
SELECT 1, 0, 40 UNION
SELECT 2, 40, 60 UNION
SELECT 3, 80, 100 ...

**0**

votes

**1**answer

51 views

### How to print categories in pandas.cut?

Notice that when you input pandas.cut into a dataframe, you get the bins of each element, Name:, Length:, dtype:, and Categories in the output. I just want the Categories array printed for me so I can ...

**0**

votes

**1**answer

29 views

### VBA in Excel: Controlling a Chart with Dynamic Ranges

I have been working on an excel model with dynamic charts. Essentially a user should be able to change the periods charted on a diagram - so fairly simple. However, I keep having issues with making ...

**1**

vote

**2**answers

46 views

### Python - How to access the current state of the range-type object returned by range()?

In Python 3, if I'm not mistaken, the range-type object created by range() generates numbers on-demand for a for-loop, in a way that is somewhat similar to a generator.
I'm wondering if it is ...

**0**

votes

**2**answers

56 views

### Create integer sequence arrays with increasing / decreasing difference between consecutive numbers

I am looking to create two different types of integer array using JavaScript: one where the difference in neighboring values steadily increases and another where the difference steadily decreases. The ...

**2**

votes

**2**answers

37 views

### Summing elements of a list that are placed only on an even number position

I want to sum the elements of a list that are placed only on an even number position.
This is what I have, but it doesn't seam to work.
code=input("SVP entrez le code :")
r=range(0,11,2)
sum=(sum(...

**0**

votes

**1**answer

47 views

### Referring to a range using variables (and filling down)

I basically want to check whether two columns have the same number of rows populated and if they don't then I would like to copy or fill down the last value in the shorter column until the columns are ...

**0**

votes

**1**answer

53 views

### Need help comparing values of two columns in different WorkBooks

I'm trying to compare two columns in two different WB let's say A and B which have only column each.
I'd like to msgbox a text whenever the value of cell in the column of A is also in the column of B.
...

**0**

votes

**3**answers

25 views

### Giving a list of Harshad numbers using Python script

After looking around on SO for similair questions and not finding any, I will give it a shot by asking it here. I'll try to be as specific as possible.
Using Python, I am trying to make a piece of ...

**-1**

votes

**0**answers

33 views

### How to select range slider handle

Is it possible to select range slider handle separately from range slider bar element with javascript/jQuery?
I can select it in CSS with input[type='range']::-webkit-slider-thumb for Chrome use but ...

**0**

votes

**0**answers

9 views

### Fix range in target sheet data sets

This code is working fine but it is pasting data for each matched column in the target sheet but I need rngCopyTo pasting data should be start from row(33) column(D:BU) instead off each column.
...

**1**

vote

**1**answer

39 views

### VBA - adapting cell ranges in workbook for email send out

I'm currently working on a piece of code where I'm sending out a daily email which has the excel file included as an attachment, as well as having the active worksheet embedded into the body of the ...

**1**

vote

**2**answers

35 views

### Sum over a range with start and end point variables in R

I have a dataframe with the following variables:
start_point end_point variable_X
1 5 0.3757
2 7 0.4546
3 7 ...

**3**

votes

**1**answer

68 views

### Date range by week number Golang

With this simple function, I can get the week number. Now, with the number of the week, how can I get the date range, started on Sunday?
import (
"fmt"
"time"
)
func main() {
Week(time....

**1**

vote

**1**answer

21 views

### solr filter query range

in my index i have a multivalued doc field named "counter". it stores values like counter:[5, 12, 75, ...] and so on.
if i try to retrieve only docs where the min value of this field is greater than ...