Thread
:
Excel Formulas
View Single Post
#
2
Posted to microsoft.public.excel.misc
Jim Rech
external usenet poster
Posts: 2,718
Excel Formulas
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.
Reply With Quote
Jim Rech
View Public Profile
Find all posts by Jim Rech