If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
converting dates into numbers | kikilein | General Discussion | 2 | October 20th, 2004 07:33 PM |
Change Start Dates without Changing Due Dates | Beth | General Discussion | 0 | August 19th, 2004 03:44 PM |
Sumproduct search between Dates | Robert Christie | Worksheet Functions | 5 | May 22nd, 2004 03:09 PM |
Charting woes with hidden dates | dustin pockets | Charts and Charting | 4 | April 15th, 2004 04:20 AM |
subtracting dates to give a whole number | Lasitter | Worksheet Functions | 2 | October 1st, 2003 09:14 AM |