Thread: Excel Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Baffled in Excel Baffled in Excel is offline
external usenet poster
 
Posts: 1
Default Excel Formulas

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.