none
Advance filtering RRS feed

  • Question

  • I am trying to isolate legitimate duplicate job nos. from a main worksheet into a separate one so I could then establish which property the record relates to. They could relate to nos.10, 12, 14, 16 anystreet but would have different meter details.  Iam trying to do it using Advanced filter based on the job no. ad whether it is a duplicate or not (could then possibly Vlookup on the house No if I have it).  Never used advanced filter before and am struggling.
    Sunday, March 8, 2020 2:45 PM