Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
verify numbering sequence 1
- Thread starter gray78
- Start date
-
1
- #2
If there is logic to the sequence, simply test the logic
eg - if you require numbers to increment by 1 then
=if(A2-A1<>1,"Error in sequence","")
if you require them to increment by 5 then
=if(A2-A1<>5,"Error in sequence","")
in both cases, copy the formula to the bottom of your data set and then use the filter to view missing items
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
eg - if you require numbers to increment by 1 then
=if(A2-A1<>1,"Error in sequence","")
if you require them to increment by 5 then
=if(A2-A1<>5,"Error in sequence","")
in both cases, copy the formula to the bottom of your data set and then use the filter to view missing items
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Thread starter
- #3
select both columns
Data>Filter>Autofilter
Filter on your 2nd column for "Error In Sequence"
This will give you the upper numbers below which there are missing numbers in teh sequence
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Data>Filter>Autofilter
Filter on your 2nd column for "Error In Sequence"
This will give you the upper numbers below which there are missing numbers in teh sequence
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Thread starter
- #5
sorry to be a pain, but, i am not understanding. I have two columns: column "A" contains the sequenced numbers I am checking and column "B" is currently blank but where I want the "Error in sequence" remark.
1. where do I place the formula?(for testing purposes, lets assume I have data in range a1:a50
2. how do I use the filter once the formula is placed in the proper cell?
Thank you
1. where do I place the formula?(for testing purposes, lets assume I have data in range a1:a50
2. how do I use the filter once the formula is placed in the proper cell?
Thank you
formula goes in cell B1
copy it down to B50
Select both columns
Data>Filter>Autofilter
select "Error In Sequence"
et voila
for datasets of that kind of size though, I would simply 'eyeball' the data
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
copy it down to B50
Select both columns
Data>Filter>Autofilter
select "Error In Sequence"
et voila
for datasets of that kind of size though, I would simply 'eyeball' the data
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question