Dear all,
i've a list of movie names with their date of telecast for the last 2 years. Each movie is repeated more than 1 times in this period. I Need to filter each movie with their first date of telecast.
Please give an idea how to find it.
Dear all,
i've a list of movie names with their date of telecast for the last 2 years. Each movie is repeated more than 1 times in this period. I Need to filter each movie with their first date of telecast.
Please give an idea how to find it.
Hi
Use the find part of find and replace that should do it for you or insert a table and filter on movie name that will find all instances of the movie.
Chris
Click my star if I helped Thanks
Thanks for the swipt response Chris,
But i have Large no of movies. I need summary data with list of movies & their first date of telecast.
if you upload your work book or a sample i think it could be done with index and match
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
Ok
Here's the file.
try this (btw i removed all your extra spaces off your titles as index and match could fail if there are more spaces in 1 than the other)
sample data.xlsx
Thank you Twiggywales,
Thats really helpful.
Just for info, i found another solution by applying vlookup.
Thank you very much guys for your valuable advises.
Regards,
Raja.
glad you got it solved.
remember to mark the thread solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks