Data validation list filter with range defined by OFFSET

		Microsoft Office Forums > Microsoft Excel > Excel
Data validation list filter with range defined by OFFSET

FAQ

Thread Tools

Display Modes

03-18-2014, 02:42 PM

gebobs

Windows 7 64bit Data validation list filter with range defined by OFFSET

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

It works fine if you specify the ranges for the Sports and the Sciences explicitly. There must be something screwy with the Offset equations you entered for them.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Range Name in Adv Filter -> NOt working	56_kruiser	Excel	2	11-20-2012 09:58 AM
How to "hard link" two adjacent cells to a data validation drop down list?	Geza59	Excel	10	10-19-2012 11:56 AM
Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err	tinfanide	Excel Programming	2	06-09-2012 10:19 AM
Data validation with IF	Klyxrastafari	Excel	1	10-03-2011 04:41 PM
Conditional data validation (list drop-down)	click4akshay	Excel	2	04-28-2011 01:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:43 AM.