Results 1 to 17 of 17

extract "unique" records depending one column

Threaded View

  1. 12-19-2018, 06:01 AM #1
    jimapos
    jimapos is offline
    Registered User
    Join Date
    05-20-2005
    Location
    Thessaloniki Greece
    MS-Off Ver
    2021
    Posts
    39

    Exclamation extract "unique" records depending one column

    Hello
    I need your help guys
    I am not able to attach the file

    I have this (quantity is the key..)

    what I have what I want
    quantity Discription price total quantity Discription price total
    George 1 apples 50 50 George 1 apples 50 50
    anna2 2 bananas 10 20 anna2 1 bananas 10 20
    Michael 1 orange 8 8 anna2 1 bananas 10 20
    George 1 bananas 10 10 Michael 1 orange 8 8
    Steve 3 lemon 7 21 George 1 bananas 10 10
    Stella 4 cheese 12 48 Steve 1 lemon 7 21
    Steve 1 lemon 7 21
    Steve 1 lemon 7 21
    Stella 1 cheese 12 48
    Stella 1 cheese 12 48
    Stella 1 cheese 12 48
    Stella 1 cheese 12 48
    If anyone can help will ne great..
    Attached Files Attached Files
    Last edited by jimapos; 12-19-2018 at 06:12 AM. Reason: attachment
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can't filter "Unique" records from Filtered range
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2018, 04:10 PM
  2. countif to return "x" for unique & "xx" for duplicate values in a column
    By Shruder in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2018, 05:31 PM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. [SOLVED] Copy Records where records = "a" at Column B - Syntax Error
    By nironto in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-11-2013, 08:04 AM
  5. [SOLVED] Extract unique values in a column that end in "ago"
    By blinks58 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2013, 06:00 PM
  6. Count the unique items in column F if E:E = "Chris" and M:M = "VIC" and N:N = "PT"
    By tyrese214 in forum Excel General
    Replies: 1
    Last Post: 07-16-2010, 02:44 AM
  7. How can I extract the digital part, e.g. "23" in "s 23 secs." in all the column cells
    By DXMM2007 in forum Excel General
    Replies: 6
    Last Post: 11-01-2007, 11:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1