Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hey guys would really love some help.
I am putting a list of the best movies of all time together in my spare time. I have movie name - year of release - director all in one coulmn. Firstle I would like to know if there is a function that I could get similar to a find/search so if I need to check the list for a title I could iinstantly see if was there rather that trapse through 1000 entries. Also I'm sure there are plenty of people out there that have done something similar and I would appreciate any ideas on how to develope the sheet. Any comments would be appreciated Kent. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi Kent
Have a look at this site for a sample template. HTH Cimjet http://office.microsoft.com/en-us/templates "Kent" wrote in message ... Hey guys would really love some help. I am putting a list of the best movies of all time together in my spare time. I have movie name - year of release - director all in one coulmn. Firstle I would like to know if there is a function that I could get similar to a find/search so if I need to check the list for a title I could iinstantly see if was there rather that trapse through 1000 entries. Also I'm sure there are plenty of people out there that have done something similar and I would appreciate any ideas on how to develope the sheet. Any comments would be appreciated Kent. |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi Kent,
If you want to stay with your current workbook, it would be more manageable if the Name, Year of Release, Director etc each had their own column. Later, you can add more columns as you think of them - eg Genre, Studio, etc. You can then easily sort by Name, Director, or by any column heading. Search macros would also be simpler to write. You can probably use DATA TEXT TO COLUMNS to separate your data, depending on how your info has been inputted. Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
Need some help to streamline my very large 2003 excel workbook | Excel Discussion (Misc queries) | |||
How to streamline this Formula? | Excel Discussion (Misc queries) | |||
streamline SUMPRODUCT | Excel Worksheet Functions |