python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - range

How can I paste ranges using variable references?

I am attempting to paste several ranges from one workbook to another using variables as the references. I was successful in running this for individual cells, but I think my syntax is wrong now that I...
test-img

Anthony L

excel

vba

copy

range

paste

Votes: 0

Answers: 0

fixing Fibonacci numbers from a range of 1 to 50 Python

I have a set of numbers from 1 to 50 and from these numbers I have to find which are Fibonacci number, after that I have to find which of these numbers contain the number 1 and 2. For example in my co...
test-img

Kamel Avad

python

range

fibonacci

Votes: 0

Answers: 1

Latest Answer

for q in range(1, 51): if isFibonacci(q) == True and '1' in str(q) and '2' in str(q): print(q) else: print('Error') This loop's variable is q, not i. You have to convert the...
test-img

Harshal Parekh

Grep IP Range Bash Script

I just got into Bash scripting and I'm having a hard time grepping a specific IP range from a file. I've tried the following: grep "213.184.111.[128][254]" example.txt Is there an easier wa...
test-img

Thijs

bash

networking

scripting

range

ip

Votes: 0

Answers: 2

Latest Answer

When awk is also possible. Use . as field separator and compare fourth field. awk -v start=128 -v end=254 -v FS=. '$4>=start && $4<=end' example.txt Output: 213.184.111.128 213.184.111....
test-img

Cyrus

Excel - Dynamic ranges without volatile formulas or VBA

I am trying to redo a particular sheet that tracks the status of certain things for each of our clients. I had this built using OFFSET but I want to know if there's a way to do it without volatile for...
test-img

cryptic989

excel

dynamic

range

non-volatile

Votes: 0

Answers: 1

Latest Answer

The INDEX function can replace OFFSET. I'm not sure how you structured your OFFSET or IF functions, but the following will work subject to tweaking: Company A 2022-01-01 -------------------- =$D$8:IND...
test-img

skepticologist

Posts

Questions

Blogs

Jobs