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 - non-volatile

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