No Links were listed yet. Go ahead and share!
Hey welcome back to the Mr. Excel Net Cast, I’m Bill Jelen. Basically, we start out with massive amounts of data and say how are we going to analyze this, we’ll let’s fire up a pivot table and see if we can solve this problem.
Hey welcome back to he Mr. Excel Net Cast, I’m Bill Jelen. Wow a great question sent in by Greg today, I had to go check this one out before I figure out if I could do it or not. Greg has a couple of range names here, something called My Dogs and something My Cats and then we’re going to set up a simple data validation here so ALT DL. We’re going to allow a list and the list is going to be this range here where they can choose dogs or cats, click okay.
Alright so now that works, right you can choose dogs or cats. Now here is Greg’s problem. Greg says then once they have chosen that I want to have a second list that gives them either collie, poodle, spaniel, or tabby, Siamese, hairless depending on what they chose and the hassle is that these names don’t match exactly. See it has the word my before it. Now, I could argue with Greg, hey just take the word my out but let’s say that we can’t so our second choice here is data validation.
We’re going to allow a list and usually what we put in here is a formula that is the indirect of G1 but it works if we do equal indirect of the word my “&G1” so what’s that going to do that’s going to take the word my and put it before dogs. So we choose dogs here. We should get a list of dogs from A1. If we choose cats here we should get tabby, Siamese, hairless. So let’s try it alright so we choose dogs coming down here and it gives me the list of dogs. If we instead would choose cats and then come here check it out the list has changed dynamically to go grab the my cats range very, very cool trick so I want thank Greg for sending that great question in.
We’ll thank you for stopping by we’ll see you next time for anther net cast for Mr. Excel.
Transcription by:
Scribe4you Transcription Services