Hi Excel Guru's,
I have sales orders with many lines items.
Like:
80 10
80 20
98 10
98 20
108 10
108 20
108 30
108 40
108 50
I am looking for the excel formula for the below requirement
80 10
- 20
98 10
- 20
108 10
- 20
- 30
- 40
- 50
Regards
Odaiah Pelleysales order with line items.xls
Hi Guru's
Please find the expected results in sheet1.
Regards
Odaiah Pelley
uday,
Would something like the attached work for you?
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Hi
I have 10,000 sales orders like this is for only 3 sales orders.
Regards
Odaiah Pelley
uday,
Is there a question hidden somewhere in your last post? If so, A) is it directed at me, and B) does the layout I proposed work for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks