Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Sort and Filter Question
Hello,
I am working with data from two reports at work, one is MS Note Pad and the other is a company system report. I have imported the information from Note Pad into Excel. The data I now have in Excel is the following; Customer Purchase Order Number Customer Name My company’s part number Quantity required for each Customer Purchase Order Number My question is how do I sort this information so that I can see 1) the report sorted by part number from lowest to highest 2) see the customer name for each part number and the quantity 3) a total for that part number required on all orders. I want the Excel report to look like this: PO no. Customer Name Part Number Qty 16911955 SAFEWAY PORTLAND 0004142-015 9 16914908 SAFEWAY STOCKTON 0004142-015 14 23 Any help would be appreciated |
#2
|
|||
|
|||
Quote:
after importing into excel. get the data in the form of pivot table and arrange the data in ascending order as per your requirements with totals at row/column level all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort / Filter in excel | Excel Discussion (Misc queries) | |||
Excel 07 Sort & Filter A to Z | Excel Discussion (Misc queries) | |||
Excel changes formula after data sort/filter, please help. | Excel Discussion (Misc queries) | |||
Excel 2007 can not filter / sort in sheet with 657,000 rows | Excel Discussion (Misc queries) | |||
Excel 2007 data corruption using sort within a filter. | Excel Discussion (Misc queries) |