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

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>