Several Dates -Verify

[zeek]

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

 

[Bob Phillips]

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?

 

[zeek]

no,

to the second part only the dates on the each row need to match.

 

[zeek]

oops.

columns A1-F1 it is early a.m. here.

rows approximately 23000

sorry.

looks like it is going to be a long day.

 

[Ola]

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.

 

[Bob Phillips]

Okay, in G1

=If(Countif(A1:F1,A1)<6,"Oops","")

and copy down.

But if they all have to be the Same, why not just default B1:F1 to the same
as A1, no mistakes then?

 

[zeek]

Bob,

The formula works great.

This is a report pulled from another source. For inspection purposes this
makes finding the ones that are not the same much easier than flipping
pages.

Thanks and have a good weekend.

lomax