Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
will vlookup work for me?
My spreadsheet shows a row per product each customer has bought e.g. if a
customer has bought a book and a dvd from us, it will show on two rows. How do I manipulate this data so that there is 1 row for each customer and then detailing in two different columns what products were bought? Each customer has a unique reference that would be the same on each transaction - would vlookup help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
will vlookup work for me?
If you don't have too many different products, you could create a pivot
table from the list, to get a count of each item sold per customer. There are instructions and links he http://www.contextures.com/xlPivot01.html Put customers in the row area and products in the column area. Put the unique reference in the data area, as Count of unique reference. Phish76 wrote: My spreadsheet shows a row per product each customer has bought e.g. if a customer has bought a book and a dvd from us, it will show on two rows. How do I manipulate this data so that there is 1 row for each customer and then detailing in two different columns what products were bought? Each customer has a unique reference that would be the same on each transaction - would vlookup help me? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup does not work between 71% to 79% refernceing roundup numb | Excel Worksheet Functions | |||
Need Vlookup to work with formula in reference cell | Excel Discussion (Misc queries) | |||
IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
VLOOKUP won't work | Excel Worksheet Functions |