Dublicate Atticle finding with two condition

Closed
Singh - Dec 14, 2009 at 06:42 AM
 Trowa - Dec 15, 2009 at 08:16 AM
Hello,


I want to find the which aticles have MvT- 303 & 305 made


Reference Articl Qty Site MvT
TO2011200000004 1000091 100 9 303
TI2009200000002 1000091 100 9 305
TO2009200000014 1000092 -60 9 303
TO2053200000002 1000101 10 9 303
TI2009200000003 1000101 10 9 305
TO2009200000020 1000885 -5 9 303
TO2009200000001 1000885 -12 9 303
TO2009200000003 1002181 -5 9 303
TO2009200000004 1002181 -5 9 303
TO2053200000002 1003413 50 9 303
TO2260200000001 1003413 60 9 303
TI2009200000003 1003413 50 9 305
TI2009200000001 1003413 60 9 305
TO2009200000021 1003564 -18 9 303
TO2009200000029 1005272 -44 9 303
TO2009200000001 1005272 -12 9 303
TO2009200000021 1005563 -82 9 303
TO2053200000023 1006076 50 9 303
TI2009200000013 1006076 50 9 305
TO2259200000002 1006451 60 9 303
TO2260200000001 1006451 48 9 303
TI2009200000005 1006451 60 9 305
TI2009200000001 1006451 48 9 305
TO2053200000002 1006511 60 9 303
TO2260200000001 1006511 50 9 303
TI2009200000003 1006511 60 9 305
Related:

3 responses

Hi Singh,

The only values in the MvT column are 303 and 305.

So ALL Atticle (or aticles or Articl) have been made by MvT 303 and Mvt 305.

If you want to know which Atticle (or aticles or Articl) have been made by MvT 303 apply the autofilter (Data>Filter>Autofilter) or sort the data by column MvT (Select data then Data>Sort...).

Is this the answer you are looking for? If not, then ask again in more detail.

Best regards,
Trowa
1
I want to find that articles have made the both movt- 303 & 305 simultaniously in the given data .

I can use the filtering to find the only Movt-303 or 305 at a time of all articles after sorting

Please help to find the same articles having the both MovT 303 & 305.

Regards
0
closeup22 Posts 8922 Registration date Friday May 15, 2009 Status Member Last seen October 7, 2010 2,099
Dec 14, 2009 at 08:41 AM
hello sir,

press Ctrl+F

and type the letter or number and press on find next

Thanks
0
Hi Singh,

It took me quite some time to figure out your query and my solution isn't a pretty one, but at least it gets the job done.

Start by copying both the Article and the MvT columns and paste them outside your list next to each other.
When I copied your list it consumed the range A1:E27. So I pasted the copied columns in range A29:B55, but of course you can place it anywhere you want.
Now select range A29:B55 and go to Data>Filter>Advanced filter.
On the Advanced filter window select "Copy to another location", copy to range D29:E55, select "Unique records only" and click OK.
Now use F30 to input the following formula: =IF(D30=D31,D30,"").
Drag the formula in F30 down untill you reach the end of the list, in this case F47.

Now feast your eyes on the result in range F30:F47. Every article listed here have both MvT 303 and 305.

Can you work with this?

Best regards,
Trowa
0