As promised, here's link to a workbook that has the way I described earlier
working in a worksheet. Two other worksheets in the workbook show how to use
the SUMPRODUCT() portion of it along with a list to validate the stages shown
next to order numbers, and how to use VLOOKUP() instead of the CHOOSE()
function to check on the status of any order number in a long list of order
numbers that may be all mixed up.
http://www.jlathamsite.com/uploads/C...forBaffled.xls (Excel 97-2003
format 25 KB - no macros)


"Baffled in Excel" wrote:

Thanks much Jim, that is a start. I'm looking something to recognize the
four required entries and tell me when one is missing. That formula is a
start though.

"Jim Rech" wrote:

If I had an entry in A1 and I wanted a formula to tell me if A2 through A5
did not have the same entry, I'd put this formula in a nearby cell like A2:
=IF(SUMPRODUCT((A1=A2:A5)*1)=4,"","Incomplete")

I doubt this is what you want but maybe it's a start.

--
Jim
"Baffled in Excel" <Baffled in wrote in
message ...
|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.