Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Several Dates -Verify
Greetings,
I have 6 cells A1 - A6 with dates. Approximately 23000 Rows. They should be the same, however, fat-fingers are involved making inputs. What can be used to see if they are the same? Thanks lomax |
#2
|
|||
|
|||
A1-A6 are 6 rows. How does that square with 23000 rows? And what exactly do
you mean by the same, all 23000 dates should be the same date? -- HTH Bob Phillips "zeek" wrote in message news:sGrGd.11223$Tf5.9693@lakeread03... Greetings, I have 6 cells A1 - A6 with dates. Approximately 23000 Rows. They should be the same, however, fat-fingers are involved making inputs. What can be used to see if they are the same? Thanks lomax |
#3
|
|||
|
|||
no,
to the second part only the dates on the each row need to match. "Bob Phillips" wrote in message ... A1-A6 are 6 rows. How does that square with 23000 rows? And what exactly do you mean by the same, all 23000 dates should be the same date? -- HTH Bob Phillips "zeek" wrote in message news:sGrGd.11223$Tf5.9693@lakeread03... Greetings, I have 6 cells A1 - A6 with dates. Approximately 23000 Rows. They should be the same, however, fat-fingers are involved making inputs. What can be used to see if they are the same? Thanks lomax |
#4
|
|||
|
|||
oops.
columns A1-F1 it is early a.m. here. rows approximately 23000 sorry. looks like it is going to be a long day. "Bob Phillips" wrote in message ... A1-A6 are 6 rows. How does that square with 23000 rows? And what exactly do you mean by the same, all 23000 dates should be the same date? -- HTH Bob Phillips "zeek" wrote in message news:sGrGd.11223$Tf5.9693@lakeread03... Greetings, I have 6 cells A1 - A6 with dates. Approximately 23000 Rows. They should be the same, however, fat-fingers are involved making inputs. What can be used to see if they are the same? Thanks lomax |
#5
|
|||
|
|||
Hi,
Try this: ColA: your 23.000 values starting in A3 ColB: the formula below Row1: validation list (the dates) =ISERROR(VLOOKUP(A3,$A$1:$F$1,1,0)) --- False or True. Copy down to B23000. Use Autofilter to find all True. Ola To avoid 'fat-fingers', try Input Validation: This will mean that you only Allow any of your 6 dates. 1. Select all your 23.000 values 2. Goto menu: Data/Validation/ 3. Select: Tab; Validation, Allow; List 4. Then select your range with the 6 dates, hit Enter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
Entering dates in Excel 2002 | Excel Discussion (Misc queries) | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions |