Connect columns, with restrictions
 

Hi all,

Hope you can help me out with this problem.

One column is made up of codes (numbers (1-100), which are repeated and not
arranged in a certain way). The column next to it is composed of minutes
spend to complete a particular code (minutes change).

There are in total 33 codes, out of a possible 100 I am interested in.

How can I extract, or identify (True/False?) the minutes that belong to the
33 codes? (I have tried via OR statement, however it is limited to 30
epressions).

Thanks a lot in advance.

Philipp

Put your 33 codes in another worksheet (A1:A33)

Then insert another column
and use a formula like:

=isnumber(match(a1,sheet2!a:a,0))

True means there was a match.

Philipp Andre wrote:

Hi all,

Hope you can help me out with this problem.

One column is made up of codes (numbers (1-100), which are repeated and not
arranged in a certain way). The column next to it is composed of minutes
spend to complete a particular code (minutes change).

There are in total 33 codes, out of a possible 100 I am interested in.

How can I extract, or identify (True/False?) the minutes that belong to the
33 codes? (I have tried via OR statement, however it is limited to 30
epressions).

Thanks a lot in advance.

Philipp

--

Dave Peterson

hi try this

let your data in sheet one in column a1 to a33
in onther sheet column a1 write code from 1-100, and use vlookup function in
column is
=vlookup(a1,'sheet1a1'!A1:a65536,1,0)
than use filter and remove #n/a


"Philipp Andre" wrote:

Hi all,

Hope you can help me out with this problem.

One column is made up of codes (numbers (1-100), which are repeated and not
arranged in a certain way). The column next to it is composed of minutes
spend to complete a particular code (minutes change).

There are in total 33 codes, out of a possible 100 I am interested in.

How can I extract, or identify (True/False?) the minutes that belong to the
33 codes? (I have tried via OR statement, however it is limited to 30
epressions).

Thanks a lot in advance.

Philipp

Thanks a lot Dave,

problem solved!


"Dave Peterson" wrote:

Put your 33 codes in another worksheet (A1:A33)

Then insert another column
and use a formula like:

=isnumber(match(a1,sheet2!a:a,0))

True means there was a match.

Philipp Andre wrote:

Hi all,

Hope you can help me out with this problem.

One column is made up of codes (numbers (1-100), which are repeated and not
arranged in a certain way). The column next to it is composed of minutes
spend to complete a particular code (minutes change).

There are in total 33 codes, out of a possible 100 I am interested in.

How can I extract, or identify (True/False?) the minutes that belong to the
33 codes? (I have tried via OR statement, however it is limited to 30
epressions).

Thanks a lot in advance.

Philipp

--

Dave Peterson