LBRY Block Explorer

LBRY Claims • excel-trick-how-to-create-a-validation

63ba9857e6b20661d5a7e10798d1abb416fa62e0

Published By
Created On
10 Jul 2019 23:23:24 UTC
Transaction ID
Cost
Safe for Work
Free
Yes
Excel Data Validation Dependent Lists with INDIRECT and named range in Excel spreadsheet
A common question from Excel users is along the lines of; I have a list in a cell that has used Data-Validation with the "List" option. I would like to have another cell display a list that is depended on the item chosen in my first list.

There are quite a few ways to achieve this, but the easiest by far is using the INDIRECT functions in the validation. The INDIRECT Function return the reference returned by a text string.

Here is your guide on how to add dependent data validations in excel
You will find a refresher course to data validations and two possible ways to add dependent data validations in excel.


~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

...
https://www.youtube.com/watch?v=dhJ_NMuVZwk
Author
Content Type
Unspecified
video/mp4
Language
English
Open in LBRY

More from the publisher

Controlling
VIDEO
4 AMA
Controlling
VIDEO
AMAZI
Controlling
VIDEO
HOW T
Controlling
VIDEO
THE H
Controlling
VIDEO
SIMPL
Controlling
VIDEO
HOW T
Controlling
VIDEO
ANALY
Controlling
VIDEO
HOW T
Controlling
VIDEO
A GUI