LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JR Hester
 
Posts: n/a
Default Find a "date" in a column of dates in Excel 2000

I wnat to use the find tool to immediately goto to a specific date in a column.
Is my determination correct that this only works with text or numbers and
not with dates.
I have sequential dates in every 20th cell in column A, with the
interveneing cells blank.
When I use the Find tool with the entire column selected, I receive teh
nioce little dialog box expalining that Microsoft Excell cannot find the data
searched for.

Just looking for a quick way to loacte a specific date in approximately 800
rows of data, any recommendations?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 Cannot find Outlook 2003 Frank M Setting up and Configuration of Excel 0 September 1st 05 09:40 PM
how do i find the lowest number in a column in Excel? MKA808 Excel Discussion (Misc queries) 4 August 23rd 05 07:27 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 03:19 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"