Data validation lists from pivot table data

**DonkeyOte** · 01-19-2010, 06:28 AM

Consider defining the Validation range by means of a Dynamic Named Range - see link in sig. for more info.

If needed post a sample file.

**jomili** · 03-09-2010, 11:23 AM

I have a similar problem, but the posted solution doesn't seem to work for me. I am using a dynamic named ranged, and think I have the right formula for my data validation list, but I'm still gettting blanks. Here's my formula

=OFFSET(APR!$AA$5,0,0,MATCH("*",APR!$AA:$AA,-1),1)

and I've attached a sample document. I'd appreciate some help.

Thanks

Data validation lists from pivot table data

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Data validation lists from pivot table data

Re: Data validation lists from pivot table data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions