Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
looking for a way, in excel, to organize data( by buyer) from an existing
excel spreadsheet that lists items according to when said item was auctioned( ie.. first, second, third...etc.) |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can always use a pivot tabe.
Data - Pivot Table Select the rows and columns you want (you can select entire columns if you'd like) Drag the Buyer field into the "Row Fields" section If you want to know, say, how many items a buyer bought, you can put the Items column in the Data section. If you want it broken out by how many items per day were purchased, drag the date field into the "Column Fields" section as well. "sean8690" wrote: looking for a way, in excel, to organize data( by buyer) from an existing excel spreadsheet that lists items according to when said item was auctioned( ie.. first, second, third...etc.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Subtotals in a list | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions |