List of first occurences only?

shedboyxx

New Member
Joined
Apr 13, 2011
Messages
11
Kind of a newbie Excel guy here and I'm sure this is simple.

Have CD's with title in one column, track names in another.

I can set up a filter and select one CD with accompanying tracks but I'm looking to setup a scenario where I can filter just the first occurrence of the CD Title and create a lit of results.

Ex. list
Title | Track
Led Zeppelin's Greatest Hits | Whole Lotta Love
Led Zeppelin's Greatest Hits | Heartbreaker
Led Zeppelin's Greatest Hits | The Ocean
The Beatles Greatest Hits | Let It Be
The Beatles Greatest Hits | Hey Jude
The Beatles Greatest Hits | Ticket to Ride
Frank Sinatra does Manilow | Mandy
Frank Sinatra does Manilow | Weekend in New England
Frank Sinatra does Manilow | At The Copa

...the report I want to generate (or at least a list to copy and paste)

Led Zeppelin's Greatest Hits
The Beatles Greatest Hits
Frank Sinatra does Manilow

Is there a way to do this? ...preferably without macros as I have to use it on Windows and a Mac.

TIA

JIm
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Thanks very much folks. That did it. I'm learning something new just about every week with Excel. You guys are a great help.

Jim
 
Upvote 0

Forum statistics

Threads
1,224,566
Messages
6,179,551
Members
452,927
Latest member
rows and columns

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top