Dependant Droplist showing distinct records

  • Thread starter Thread starter andrew37_37
  • Start date Start date
A

andrew37_37

Hopefully someone can help me -

I am trying to select data from five droplists each dependant on th
previous selection. The following works but the droplist display
multiple occurances where there are multiple records of the same nam
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
product while only showing distinct records in each drop list i.e A
should only appear once rather than than 6 times (one for eac
association to paper)

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

Many Thank
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data validation list drop-down values based on prior selections 2
Named Ranges 2
Advanced FIlter behaviour? 4
Interpreting HP OfficeJet d145 debug print color problems for an idiot 12
Conditional Formatting - more than 4 cell colors 5
ComboBox reports wrong record 1
URGENT!!!! creating records in a shared workbook 1
ComboBox behavior-- inconsistent... wrong record chosen 1

Back
Top