Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Find a "date" in a column of dates in Excel 2000
Hi,
Just format your date column as 3/14/1998 with the full year shown. Then the FIND should select the date you enter. CHORDially, Art Farrell "JR Hester" wrote in message ... 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? |
#3
|
|||
|
|||
Find a "date" in a column of dates in Excel 2000
Finding depends upon what you are entering in the find what: box and what your
Windows short date is set for, not what the dates are formatted to. i.e. date formatted as 23/11/2005 will not be found if short date entry is mm/dd/yyyy You would enter 11/23/2005 in the find box. Also must enter as 05/09/2005, not as 5/9/2005 Fool around with the find what: box until you get the correct syntax. Gord Dibben Excel MVP On Tue, 1 Nov 2005 08:30:16 -0800, JR Hester wrote: 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? |
#4
|
|||
|
|||
Find a "date" in a column of dates in Excel 2000
Thansk to both Gord & Art, Both answers helped, but I'm not there yet.
However you helped me realiaze what might be going on. I have formulas throughout the column to add on day to the previous. I begin each sheety with month/day/year, i.e. 11/1/05 in cell a2. Each subsequent date refereneces last date entry cell+1, ie a29=a2+1. a56=a29+1, a83=a56+1, and so on. Evidently the 'find' only works on actual cell contents, and not the results of a formula. Am I understanding the function more thouroughly now? Is there an easy way to 'find' a particular date in my list? Thanks Again! "Gord Dibben" wrote: Finding depends upon what you are entering in the find what: box and what your Windows short date is set for, not what the dates are formatted to. i.e. date formatted as 23/11/2005 will not be found if short date entry is mm/dd/yyyy You would enter 11/23/2005 in the find box. Also must enter as 05/09/2005, not as 5/9/2005 Fool around with the find what: box until you get the correct syntax. Gord Dibben Excel MVP On Tue, 1 Nov 2005 08:30:16 -0800, JR Hester wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 Cannot find Outlook 2003 | Setting up and Configuration of Excel | |||
how do i find the lowest number in a column in Excel? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |