Hi again,

regarding A1:
This cell is just for comparing and just has to be defrent to A2.
the logic in the formula is that we are comparing active cell with one cell
up and one cell down and that is why i said you should start from the second
row because if your active cell would be the first row so you don't have any
cells up your active cell and then you face to an error.

Thanks,
--
Farhad Hodjat


"Baffled in Excel" wrote:

Farhad,

First, you totally rock! Thanks for helping. I inserted this formulaa, but
I believe A1 is not pulling from the right cell. What is A1 looking for? I
inserted a new Row as you said and A1 is blank. I have the 'helper' cell as
column H, but it is still not working. Thanks a mil!

"Farhad" wrote:

Hi,

I think this works for you:

=IF(A2=A1,IF(OR(AND(F1+1=3,A2<A3),AND(F1+1=2,A2< A3)),"Wrong",F1+1),IF(AND(A2<A1,A2<A3),"wrong",1 ))

assumed your data started from A2 and the column F is empty (helper column)
so if your data starts from the first row insert a row above your data and
let it starts from the second row.

Thanks,
--
Farhad Hodjat


"Baffled in Excel" wrote:

Absolutely, thanks much!

Example:
Tracking Number Description
3D4500123 Select Item
3D4500123 Box Item
3D4500123 Deliver Item

So with this I have a Description missing, which is "load item". I want
something to tell me that this step was missed...

Hope this helps

"JLatham" wrote:

Could you give us some examples of how these things look both when all steps
are completed, and when all are not. Maybe something like:

Completed Example
A
1 12345
2 12345-01
3 12345-02
4 12345-03

Incomplete Example
A
5 23456
6 23456-01
7
8

That kind of thing?

"Baffled in Excel" wrote:

I have tracking numbers that have four similiar beginnings. For each
tracking number there "should" be four steps attached to them. I want to
create a formula or macro that tells me which tracking number does not have
all four steps on it. Each row in Excel is the tracking number, then there
are subsequent rows for each step for that tracking number, with that
tracking number listed on all four rows. Maybe the formula says True or
False or a macro that could cull them out onto a separate spreadsheet?? Tks
for helping.