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
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