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
3answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
2answers
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
43 views

Change Range Icon with Img Materialize CSS

can i change icon Range Slider from Materialize ? Thanks
-1
votes
0answers
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
4answers
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
1answer
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
1answer
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
2answers
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
2answers
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
2answers
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
1answer
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
1answer
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
3answers
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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 ...