Ask Experts Questions for FREE Help !
Ask
    lesoxnam's Avatar
    lesoxnam Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jul 6, 2012, 02:15 AM
    Show multiple entries once
    I have a column with most numbers repeated several times. In a second column I want to show each different number once only, eg:
    A B
    1234 1234
    1234 369
    1234 158
    369 1125
    369
    369
    369
    158
    158
    1125
    This is in Excel 2010 thanks.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 9, 2012, 09:42 PM
    This is exactly what the Advanced Filter was created for... here's a video tutorial using your data sample:

    Using Advanced Filter - JerryBeaucaire's library
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Multiple Entries= 10 year bar? [ 3 Answers ]

My husband has multiple entries one in 1993 and the last in September of 97. I am a US citizen... in 97 once he crossed the border he was detained by police and taken back to Mexico. Will he be barred for 10 years?

Show me how to prepare a trial balance with the following general entries [ 1 Answers ]

Prepare general journal entries for the following transactions of a new business called Pose for Pics. Aug. 1 Hashim Paris, the owner, invested $7,500 cash and $32,500 of photography equipment in The business. 1 Paid $3,000 cash for an insurance policy covering the next 24 months. 5 Purchased...

Show me some of the adjusting depreciation entries closing entry [ 30 Answers ]

Show me some of the adjusting depreciation(closing entry) entries...

Show me how to preparing general journal entries? [ 2 Answers ]

Preparing general journal Entries Prepare general journal entries for the following transactions of a new business called Pose for Pics. Aug. 1 Hashim Paris, the owner, invested $7,500 cash and $32,500 of photography equipment in The business. 1 Paid $3,000 cash for an insurance policy...

View more questions Search