LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup does not work between 71% to 79% refernceing roundup numb Glennrbt Excel Worksheet Functions 4 December 15th 05 11:55 PM
Need Vlookup to work with formula in reference cell mikeburg Excel Discussion (Misc queries) 2 August 5th 05 12:54 AM
IF / VLOOKUP formula won't work until saved tawtrey(remove this )@pacificfoods.com Excel Worksheet Functions 2 August 4th 05 11:55 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 12:09 PM
VLOOKUP won't work o1darcie1o Excel Worksheet Functions 4 December 28th 04 08:05 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"