I've been using the DV function in Excel for many years, so I was surprised when you said that the list must be in the same sheet. I usually create an extra sheet tab that houses all of my lists as sort of my reference tables and the other sheet tabs can all have drop-down lists via validation that links to that ref tab. Nevertheless, I love the instructional videos you've been sharing which have been very helpful to me as heavy Excel user. I get to rediscover functions that I've been using and I also get to find out about new functions that I weren't aware of before your video came along. Great work!
@zezalhu
9 жыл бұрын
If you name a range (calling it "location", for example) the source doesn't need to be on the same sheet :) Btw, love your videos. Cheers, José
@harolddouglas4057
3 жыл бұрын
I wish people would say what _version_ of the software is being used.
Пікірлер: 3