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

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

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

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

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.