Overclock.net › Forums › Software, Programming and Coding › Other Software › Need quick help with a filter function in excel
New Posts  All Forums:Forum Nav:

Need quick help with a filter function in excel

post #1 of 2
Thread Starter 
Hey there.
I have this spreadsheet as shown in the image that shows the purchases users did on my web page. Sometimes it shows the user once which means they made a purchase just once, while sometimes a user appears multiple time in the table which means he has made multiple transactions. What i need to do is filter the current table data to only show the first purchase the user did and not the subsequent ones. I tried my best with my limited excel knowledge but had no luck, my best bet at the moment is to do everything manually but that will take an enitre day or 2 since it is over 100000 users :l


D489

Would really appreciate if someone knows the trick for this one, it will save me valuable hours.
Jeff
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 860  MSI p55-GD85 GTX 570 8 GB ram DDR3 
Hard DriveOSPower
120gb vertex 2 ssd Win 7 - 64 bit CoolerMaster 850w 
  hide details  
Reply
Jeff
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 860  MSI p55-GD85 GTX 570 8 GB ram DDR3 
Hard DriveOSPower
120gb vertex 2 ssd Win 7 - 64 bit CoolerMaster 850w 
  hide details  
Reply
post #2 of 2
Tagging along
The box
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD 1700 AX370-Gaming 5 NVIDIA GeForce GTX 1080 Ti Corsair  
  hide details  
Reply
The box
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD 1700 AX370-Gaming 5 NVIDIA GeForce GTX 1080 Ti Corsair  
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Need quick help with a filter function in excel