Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
andrew37_37
 
Posts: n/a
Default Dependant Droplist showing distinct records


Hopefully someone can help me -

I am trying to select data from five droplists each dependant on the
previous selection. The following works but the droplist displays
multiple occurances where there are multiple records of the same name
associated with the previous selection.

=OFFSET(cat1start,MATCH(B2,cat1column,0)-1,1,COUNTIF(cat1column,B2),1)

Essentially the five list should guide a user to uniquely identify a
product while only showing distinct records in each drop list i.e A4
should only appear once rather than than 6 times (one for each
association to paper)

paper A4 100 Blue Wrapped
paper A4 100 Blue Loose
PAPER A4 100 GREEN WRAPPED
paper A4 100 Green Loose
paper A4 200 Blue Wrapped
paper A4 200 Blue Loose

Many Thanks


--
andrew37_37
------------------------------------------------------------------------
andrew37_37's Profile: http://www.excelforum.com/member.php...o&userid=25643
View this thread: http://www.excelforum.com/showthread...hreadid=390510

  #2   Report Post  
Sara Hopkins
 
Posts: n/a
Default

Hi Andrew, are you still struggling with this? I had a similar problem and
just had it resolved... it might help you too. The thread is Data Validation
dependant and unique posted on 24th & 25th August.

"andrew37_37" wrote:


Hopefully someone can help me -

I am trying to select data from five droplists each dependant on the
previous selection. The following works but the droplist displays
multiple occurances where there are multiple records of the same name
associated with the previous selection.

=OFFSET(cat1start,MATCH(B2,cat1column,0)-1,1,COUNTIF(cat1column,B2),1)

Essentially the five list should guide a user to uniquely identify a
product while only showing distinct records in each drop list i.e A4
should only appear once rather than than 6 times (one for each
association to paper)

paper A4 100 Blue Wrapped
paper A4 100 Blue Loose
PAPER A4 100 GREEN WRAPPED
paper A4 100 Green Loose
paper A4 200 Blue Wrapped
paper A4 200 Blue Loose

Many Thanks


--
andrew37_37
------------------------------------------------------------------------
andrew37_37's Profile: http://www.excelforum.com/member.php...o&userid=25643
View this thread: http://www.excelforum.com/showthread...hreadid=390510


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting specific records [email protected] Excel Discussion (Misc queries) 6 June 22nd 05 11:35 PM


All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"