Data Verification in Excel?

[NeoValence]

Hi All,

Is it possible to verify if data is sequential or not. If so how would one accomplish this?

I'm creating a serial # log sheet if that helps at all. I want each serial # that's entered to be equal to the previous cell incremented by one.

Thanks in Advance,

Neo

 

[SkipVought]

Hi,

use a formula, referencing the previous cell like...
[tt]
In C2: =C1+1
[/tt]
Check out the Data > List... feature, which can automatically put the formula in the new row as you begin entering data in that row.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[NeoValence]

Skip,

Thanks for the suggestion. It got me on the right track. Though I ended up taking a different route since I'm using Office 2007 and I assume you are not.

I had to first select the column to contain the serial# data, then click the "Data" tab, then click the "Data Verification" button, then in the "Settings" tab for the "Validation Criteria" group, select "Whole Number" in the "Allow:" drop down box, then selct "equal to" in the "Data:" drop down box and finally enter "=ROW()+4998"(minus the quotes) in the "Value:" text box(where 4998 is the starting product serial# minus 2 since data entry begins in row 2 of the data sheet).

I know this is all elementary stuff so forgive me for being such a noobie.

Thanks,

Neo