Need some help identifying orders over more then one area

[Justin Greenwood]

Ok so I have 1000 orders and some of these orders are from 2 parts of the warehouse.
The order number is the same for the whole order.
What I need to do is identify some how these orders that are from 1 or more zones.

Sample file attached.

 

[Justin Greenwood]

Some thing like this is what I am after:
AD098368681 SIP
AD098368681 TEN small
AD098368681 TEN small
AD098368684 TEN small
AD098368684 TEN small
AD098368684 TEN small

 

[vletm]

... or something like this?

 

[Justin Greenwood]

... or something like this?

Thank you how I missed pivot table I don,t know .....
That kind of works but I need to be able to filter out the orders with more then one zone

 

[Justin Greenwood]

Ah managed to work that bit out now. Just to high light them in the table

 

[vletm]

... next samples
1) Filtering
2) Pivot
If still something is missing
then need better sample output.

 

[Justin Greenwood]

Ok here is the full list.
Sheet 2 I have taken your pivot table and done a

COUNTIF('range',">0")

to give me the number of zones.

On sheet 1 You will see where I have started to "Manually highlight theses".

What I need to do is highlight all the muti zone orders

Thank you for your help so far!!

 

[vletm]

...much easier after know output ...
1) no need that another sheet
2) 'AD'... should be sorted
3) use that PIVOT, do not change layout
4) Press [Do It!] to get highlite
> Ideas ... Questions?

 

[Justin Greenwood]

You sir are great.

 

[rahulshewale1]

hii justin,

please find attached formula base solution..

Regard
Rahul

 

[Justin Greenwood]

...much easier after know output ...
1) no need that another sheet
2) 'AD'... should be sorted
3) use that PIVOT, do not change layout
4) Press [Do It!] to get highlite
> Ideas ... Questions?

Love it it works great for me. Maybe you could PM me the details of how the VB is working Then I would have a better understanding.