List all occurances

[junior1505]

Greetings from India,
Have two different worksheets containing
1. Production details.
2. Delivery details.
want to combine them as one but cannot use Vlookup as the both worksheet has the same item a number of times.
could anyone explain anyother method or formula.
did notice sometime before about a thread mentioning all occurances. but cannot see it now.
thanks.

[davesexcel]

Check out this thread, hopefully it can help you
http://www.excelforum.com/excel-gene...l-results.html

[junior1505]

Greetings Davesexcel,
Thanks for the suggestion and have seen the post.
well am learning a lot of excel from you all.
forum members have all been quite generous.
thanks, Lord bless.

[junior1505]

<SOLVED>
is this way to close the post?
thanks.

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[teylyn]

marked solved, as OP cannot see edit button anymore.