Related:
- Dublicate Atticle finding with two condition
- Ps3 not finding update on usb - Guide
- If condition in excel - Guide
- Finding @ on keyboard - Guide
- Air condition lidl - Home - Apps & Sites
- Available memory less than 15mb condition zero - Guide
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
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
closeup22
Posts
8923
Registration date
Friday May 15, 2009
Status
Member
Last seen
October 7, 2010
2,099
Dec 14, 2009 at 08:41 AM
Dec 14, 2009 at 08:41 AM
hello sir,
press Ctrl+F
and type the letter or number and press on find next
Thanks
press Ctrl+F
and type the letter or number and press on find next
Thanks
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
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
Dec 14, 2009 at 10:35 PM
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