Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search through dates
This is probably something simple, however I am knew to excel.
I am creeting an simple electronic diary. I have a column of dates (A14:A74) and would like to have a search box in the same worksheet to search through the dates and bring me to the one that i enter... is there a simple way to do this???? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search through dates
smudgedwhiteink;360288 Wrote: This is probably something simple, however I am knew to excel. I am creeting an simple electronic diary. I have a column of dates (A14:A74) and would like to have a search box in the same worksheet to search through the dates and bring me to the one that i enter... is there a simple way to do this????The simplest robust way is to go to your menubar EDITFIND enter your date and hit find next, the found cell will then be selected, if you are using Excel 2007 then you can use FIND & SELECT on the far right of the home tab on the ribbon. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=101048 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
Functions (search within search result) | Excel Worksheet Functions | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Search for most recent date from list of dates | Excel Discussion (Misc queries) | |||
Search between two dates | Excel Discussion (Misc queries) |